WebADI_配置设定10_设定默认值Attribute Default Value（案例）

PARAMETER    gl:budgetName
PARAMETER    gl:currency
PARAMETER    gl:ledgerName
PARAMETER    gl:organization
PARAMETER    gl:periodYear
PARAMETER    gl:updateMode

SQL    SELECT $PARAM$.PER:India_Medical_Bill_Param FROM DUAL
SQL    SELECT $PROFILES$.PER_RI_WEBADI_BG_ID FROM DUAL
SQL    SELECT ACCESS_SET_ID FROM GL_ACCESS_SETS WHERE ACCESS_SET_ID = $PROFILES$.GL_ACCESS_SET_ID
SQL    SELECT ADB_FLAG FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID=:SOB_ID
SQL    SELECT AMS_ADI_UPLOAD_BATCH_S.nextval from dual
SQL    SELECT BUDGET_ENTITY_ID FROM GL_BUDGET_ENTITIES WHERE NAME = $table$.GL_BUDGET_INTERFACE.BUDGET_ENTITY_NAME
SQL    SELECT BUDGET_VERSION_ID FROM GL_BUDGET_VERSIONS WHERE BUDGET_NAME = $table$.GL_BUDGET_INTERFACE.BUDGET_NAME
SQL    SELECT CLASSIFICATION_ID  FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'CA' AND CLASSIFICATION_NAME = 'Pre-Tax Deductions'
SQL    SELECT CLASSIFICATION_ID  FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'CA' AND CLASSIFICATION_NAME = 'Supplemental Earnings'
SQL    SELECT CLASSIFICATION_ID  FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'CA' AND CLASSIFICATION_NAME = 'Taxable Benefits'
SQL    SELECT CLASSIFICATION_ID FROM PAY_ELEMENT_CLASSIFICATIONS WHERE LEGISLATION_CODE = 'US' AND CLASSIFICATION_NAME = 'Pre-Tax Deductions'
SQL    SELECT EGO_IPI_TRANSACTION_ID_S.NEXTVAL FROM DUAL
SQL    SELECT FND_CONCURRENT_REQUESTS_S.NEXTVAL FROM DUAL
SQL    SELECT MEANING FROM FA_LOOKUPS WHERE LOOKUP_TYPE = 'ASSET TYPE'
SQL    SELECT MEANING FROM FA_LOOKUPS WHERE LOOKUP_TYPE = 'FADI_FEEDER_SYSTEM'
SQL    SELECT MEANING FROM FA_LOOKUPS WHERE LOOKUP_TYPE = 'YESNO' AND LOOKUP_CODE = 'YES'
SQL    SELECT NAME FROM GL_ACCESS_SETS WHERE ACCESS_SET_ID = $PROFILES$.GL_ACCESS_SET_ID
SQL    SELECT OZF_RESALE_BATCH_NUMBER_S.NEXTVAL FROM DUAL
SQL    SELECT TO_CHAR(SYSDATE,'DD-MON-RRRR') FROM DUAL
SQL    SELECT TRUNC(SYSDATE) from dual
SQL    SELECT USERENV('LANG') FROM DUAL
SQL    SELECT USER_JE_SOURCE_NAME FROM GL_JE_SOURCES_V WHERE JE_SOURCE_NAME = $PROFILES$.GLDI_JOURNAL_SOURCE
SQL    SELECT fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE') FROM dual
SQL    SELECT fnd_profile.value('PER_BUSINESS_GROUP_ID') from dual
SQL    SELECT gcs_dimension_members_t_s.NEXTVAL FROM DUAL
SQL    SELECT gcs_entry_headers_s.NEXTVAL FROM DUAL
SQL    SELECT gcs_hier_members_t_s.NEXTVAL FROM DUAL
SQL    SELECT meaning FROM IGI_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N'
SQL    SELECT name FROM hr_operating_units WHERE organization_id = $PARAM$.orgId
SQL    SELECT name FROM hr_operating_units WHERE organization_id = $PROFILES$.DEFAULT_ORG_ID
SQL    Select $PARAM$.ORGANIZATION from dual
SQL    Select $PARAM$.test_param from dual
SQL    Select id_flex_structure_name from fnd_id_flex_structures_v where application_id = 101 and id_flex_code = 'GL#' and id_flex_num = $PARAM$.COA_ID
SQL    Select trunc(sysdate) from dual
SQL    select $PROFILES$.PER_RI_WEBADI_BG_ID from dual
SQL    select $PROFILES$.PQP_RI_INTERFACE_CODE from dual
SQL    select AMS_ADI_UI_INSTANCE_S.nextval from dual
SQL    select AMS_ADI_UPLOAD_BATCH_S.nextval from dual
SQL    select AMW_AUDIT_PROCEDURE_INT_S1.nextval from dual
SQL    select AMW_CONSTRAINT_INTERFACE_S1.nextval from dual
SQL    select ITA_SETUP_REC_INTF_S2.nextval from dual
SQL    select LEGISLATION_CODE from per_business_groups where business_group_id =$PROFILES$.PER_RI_WEBADI_BG_ID
SQL    select PA_FP_WEBADI_UPLOAD_INF_S.nextval from dual
SQL    select RESOURCE_NAME from jtf_rs_resource_extns_vl where user_id = $env$.userid
SQL    select amw_ap_interface_s1.nextval from dual
SQL    select amw_ctrl_interface_s1.nextval from dual
SQL    select amw_key_acc_interface_s2.nextval from dual
SQL    select amw_processes_interface_s2.nextval from dual
SQL    select amw_rcm_org_interface_s2.nextval from dual
SQL    select amw_risk_ctrl_interface_s2.nextval from dual
SQL    select country_name from jtf_loc_hierarchies_vl where location_type_code = 'COUNTRY' and location_hierarchy_id = fnd_profile.value('AMS_SRCGEN_USER_CITY')
SQL    select currency_code from gl_ledgers where ledger_id = $PARAM$.LedgerId
SQL    select fnd_profile.value('AMS_SRCGEN_USER_CITY') from dual
SQL    select fun_system_options_pkg.get_default_currency() from dual
SQL    select gcs_entry_headers_s.nextval from dual
SQL    select legislation_code from per_business_groups where business_group_id = $PROFILES$.PER_RI_WEBADI_BG_ID
SQL    select meaning from gl_lookups where lookup_type = 'GL_HIST_RATES_USAGE' and lookup_code = 'Standard'
SQL    select name from fnd_currencies_vl where currency_code = fnd_profile.value('AMS_DEFAULT_CURR_CODE')  and enabled_flag = 'Y'
SQL    select name from fnd_timezones_vl where upgrade_tz_id = fnd_profile.value('CLIENT_TIMEZONE_ID')
SQL    select name from gl_ledgers where ledger_id = $PARAM$.LedgerId
SQL    select ota_general.get_org_name($PROFILES$.PER_RI_WEBADI_BG_ID) from dual
SQL    select resource_id from jtf_rs_resource_extns where user_id = $env$.userid
SQL    select show_rate_type from gl_lookups_rate_type_v where rate_type = 'H'
SQL    select to_char(sysdate,'DD-MON-RRRR') from dual
SQL    select to_char(sysdate,'MM/DD/RRRR') from dual
SQL    select user_name from bne_integrators_tl where integrator_code = 'FUN_SINGLE_BATCH_INTG' and source_lang = userenv('LANG') and language = userenv('LANG')

TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.BUSINESS_GROUP_NAME
TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.P_DATE_EFFECTIVE
TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.P_DATE_FROM
TABLELOOKUP    $TABLE$.INSERT_BATCH_LINES.STYLE
TABLELOOKUP    $TABLE$.UP_VSET_VALUE.P_FLEX_VALUE
TABLELOOKUP    $table$.AMS_ADI_CAMPAIGNS_INTERFACE.CURRENCY_CODE
TABLELOOKUP    $table$.AMS_ADI_CAMPAIGNS_INTERFACE.OBJECT_NAME
TABLELOOKUP    $table$.AMS_ADI_CAMPAIGNS_INTERFACE.PARENT_OBJECT_ID
TABLELOOKUP    $table$.FA_MASS_ADDITIONS.FIXED_ASSETS_COST
TABLELOOKUP    $table$.FA_MASS_ADDITIONS.FIXED_ASSETS_UNITS
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.ASS_ID
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.CAL_TYPE
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.CI_SEQUENCE_NUMBER
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.LOCATION_CD
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.UNIT_CD
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.UNIT_CLASS
TABLELOOKUP    $table$.IGS_AS_AIO_INTERFACE.UOO_ID
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.ALTERNATE_CODE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.ANONYMOUS_ID
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.BATCH_DATE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.CAL_TYPE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.CI_SEQUENCE_NUMBER
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.COURSE_CD
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.GRADE
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.LOCATION_CD
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.MARK
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.PERSON_NUMBER
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.UNIT_CD
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.UNIT_CLASS
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.UOO_ID
TABLELOOKUP    $table$.IGS_AS_UG_INTERFACE.USER_ID
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.ANONYMOUS_ID
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.BATCH_DATE
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.COURSE_CD
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.PERSON_NUMBER
TABLELOOKUP    $table$.IGS_PR_SPO_INTERFACE.PROGRESSION_OUTCOME_TYPE
TABLELOOKUP    $table$.INSERT_BATCH_LINES.P_DATE_FROM
TABLELOOKUP    $table$.JTY_WEBADI_OTH_TERR_INTF.HEADER
TABLELOOKUP    $table$.JTY_WEBADI_OTH_TERR_INTF.LAY_SEQ_NUM
TABLELOOKUP    $table$.JTY_WEBADI_OTH_TERR_INTF.USER_SEQUENCE
TABLELOOKUP    $table$.gcs_hier_members_t.PARENT_VS_DISPLAY_CODE
TABLELOOKUP    $table$.upload_header.p_operating_entity_id