ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 92C63F4C20A21E85E053BB6B63585CC8 CST Cost Type Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 5F14F6E17DA94AB8A633F3A05B616448Y select case when nvl2(:p_autopopulate_upload_status,'Y','N')='Y' then xxen_upload.action_meaning(xxen_upload.action_update) else null end action_, case when nvl2(:p_autopopulate_upload_status,'Y','N')='Y' then xxen_upload.status_meaning(xxen_upload.status_new) else null end status_, case when nvl2(:p_autopopulate_upload_status,'Y','N')='Y' then xxen_util.description('U_EXCEL_MSG_VALIDATION_PENDING','XXEN_REPORT_TRANSLATIONS',0) else null end message_, to_number(null) request_id_, null modified_columns_, null row_id, cct_t.cost_type target_cost_type, mp.organization_code, br.resource_code, br.description resource_description, br.unit_of_measure, xxen_util.meaning(br.cost_element_id,'CST_COST_CODE_TYPE',700) cost_element, crc.resource_rate, null delete_resource_rate, xxen_util.display_flexfield_context(702,'CST_RESOURCE_COSTS',crc.attribute_category) attribute_category, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE1',crc.rowid,crc.attribute1) rsc_rate_attribute1, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE2',crc.rowid,crc.attribute2) rsc_rate_attribute2, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE3',crc.rowid,crc.attribute3) rsc_rate_attribute3, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE4',crc.rowid,crc.attribute4) rsc_rate_attribute4, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE5',crc.rowid,crc.attribute5) rsc_rate_attribute5, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE6',crc.rowid,crc.attribute6) rsc_rate_attribute6, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE7',crc.rowid,crc.attribute7) rsc_rate_attribute7, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE8',crc.rowid,crc.attribute8) rsc_rate_attribute8, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE9',crc.rowid,crc.attribute9) rsc_rate_attribute9, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE10',crc.rowid,crc.attribute10) rsc_rate_attribute10, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE11',crc.rowid,crc.attribute11) rsc_rate_attribute11, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE12',crc.rowid,crc.attribute12) rsc_rate_attribute12, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE13',crc.rowid,crc.attribute13) rsc_rate_attribute13, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE14',crc.rowid,crc.attribute14) rsc_rate_attribute14, xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE15',crc.rowid,crc.attribute15) rsc_rate_attribute15, 1 process_flag, 2 import_cost_option, :p_upload_mode upload_mode, :p_do_cost_rollup rollup_costs, :p_rollup_range rollup_type, :p_rollup_option rollup_option, :p_rollup_inc_unimp_ecn_flag rollup_unimpl_ecos, null upload_row from cst_cost_types cct_s, cst_cost_types cct_t, mtl_parameters mp, bom_resources br, cst_resource_costs crc where 1=1 and :p_upload_mode=:p_upload_mode and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and cct_s.cost_type=:p_source_cost_type and cct_t.cost_type=:p_target_cost_type and br.organization_id=mp.organization_id and br.cost_element_id in (3,4) and br.functional_currency_flag<>1 and nvl(br.allow_costs_flag,1)=1 and nvl(br.disable_date,sysdate)>=sysdate and cct_s.cost_type_id=crc.cost_type_id(+) and br.organization_id=crc.organization_id(+) and br.resource_id=crc.resource_id(+) and (crc.rowid is not null or nvl(:p_include_no_rate_resources,'N')='Y') Initial version U :Rollup_Costs is null or :Rollup_Type is not null and :Rollup_Option is not null A xxen_cst_upload.insert_res_rate_interface xxen_cst_upload.submit_cost_import US CST Resource Rate Upload CST Resource Rate Upload ======================== This upload can be used to - Upload new Resource Rates - Download the current Resource Rates for a Cost Type, update, and upload the amended rates - Download the current Resource Rates from a Source Cost Type and upload them to a different Target Cost Type - Delete existing Resource Rates Resource Rates apply to rate based Resource and Outside Processing sub-elements (sub-elements whose charge basis is not currency based). The rates are imported via the Oracle Cost Import Process. NOTE: You can only upload rates to cost types that are not flagged as frozen and are flagged as updateable. This includes the rates cost types used by average costing organizations (e.g. AvgRates). NOTE: The Cost Import Process cannot delete a Resource Rate, so a row flagged for deletion is not sent to it. Set the Delete Resource Rate column to Yes and the rate is removed directly when the row is processed, in the same way as the Resources form removes it. Deletion is not allowed for frozen standard cost types or for cost types which do not allow updates. Deleted rates are not covered by the Cost Rollup. Run a rollup separately if the removal should be reflected in item costs. Optionally, the upload can perform a Cost Rollup after the rates have been imported. The Cost Rollup can be performed for - Specific item - a cost rollup is done only for rolled up items whose cost details in the Target Cost Type reference the uploaded resources - All items - the 'Supply Chain Cost Rollup - Print Report' concurrent request is submitted to rollup all items within each organization rates are uploaded to NOTE: In 'All items' mode the Supply Chain Cost Rollup requests are submitted asynchronously and the upload does not wait for them. In 'Specific item' mode, the items to roll up are derived from the existing cost details in the Target Cost Type. Items that have never been rolled up in the Target Cost Type are therefore not found, even if their routings use an uploaded resource - use 'All items' mode for those. Parameters ========== Target Cost Type (Required) - The Cost Type to which the Resource Rates are to be uploaded. Mode (Required, Default: Remove and replace cost information) - - Remove and replace cost information: an existing rate for the same resource is replaced - Insert new Cost Information Only: uploading a rate for a resource that already has one raises an error Auto Populate Upload Columns (Default: Yes) - Applies to downloaded rates only. If set to Yes, the downloaded records are flagged ready for upload even if no changes have been made. If left blank, records are only flagged for upload when the user amends them. Source Cost Type - Optionally specify the Cost Type from which to download the current Resource Rates, to amend them or to copy them to a different Target Cost Type. Include Resources without a Rate - Set to Yes to also download rate eligible resources that do not yet have a rate in the Source Cost Type, with a blank rate ready to be entered. To rate new resources for a cost type, select that cost type as both Source and Target Cost Type. Rollup Costs - set to Yes to do a cost rollup after the rates are imported Rollup Type - All items or Specific item Rollup Option - Single level rollup or Full cost rollup Organization Code / Resource / Resource Like - Optionally restrict the resources to be downloaded. Notes on the Upload =================== The upload supports the Resource Cost Information descriptive flexfield. The attribute columns are named according to the descriptive flexfield segments setup. Rollup Type and Rollup Option must be specified in order to Rollup Costs Enginatics R12 only Upload 1=1 :p_autopopulate_upload_status :p_do_cost_rollup :p_include_no_rate_resources :p_rollup_inc_unimp_ecn_flag :p_rollup_option :p_rollup_range :p_source_cost_type :p_target_cost_type :p_upload_mode 1 -10 :p_rollup_inc_unimp_ecn_flag LOV custom Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='SYS_YES_NO' and :$flex$.Rollup_Costs='Y' order by value 2 US Rollup Unimplemented ECOs 2 10 :p_target_cost_type LOV custom Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate+1)>sysdate and cct.allow_updates_flag=1 and cct.frozen_standard_flag<>1 and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type Y US Target Cost Type 3 20 :p_upload_mode LOV Oracle CST_SRS_RUN_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_RUN_OPTION' order by value,description 2 Y US Mode 4 30 :p_autopopulate_upload_status LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Auto Populate Upload Columns 5 40 :p_source_cost_type LOV CST Cost Type 92C63F4C20A21E85E053BB6B63585CC8 Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type US Source Cost Type 6 50 :p_include_no_rate_resources LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Include Resources without a Rate Set to Yes to also download rate eligible resources that do not yet have a rate in the Source Cost Type, with a blank rate ready to be entered. To rate new resources for a cost type, select that cost type as both Source and Target Cost Type. 7 60 :p_do_cost_rollup LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Rollup Costs? When set to Yes, a cost rollup will be performed after the resource rates are imported. 8 70 :p_rollup_range LOV custom Y select ml.lookup_code id, ml.meaning value, case ml.lookup_code when 1 then 'All Items' when 2 then 'Items using the uploaded resources' end description from mfg_lookups ml where ml.lookup_type='CST_ITEM_RANGE' and ml.lookup_code in (1,2) and :$flex$.Rollup_Costs='Y' order by value 2 US Rollup Type All items: a Cost Rollup concurrent request will be submitted for all items in the organization. Specific item: a Cost Rollup will be performed only for rolled up items whose cost details in the Target Cost Type reference the uploaded resources. 9 80 :p_rollup_option LOV custom Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='CST_ROLLUP_TYPE' and :$flex$.Rollup_Costs='Y' order by value 2 US Rollup Option 10 90 1=1 mp.organization_code=:p_organization_code LOV custom Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and exists (select null from cst_cost_types cct where cct.cost_type=:$flex$.target_cost_type and nvl(cct.organization_id,ood.organization_id)=ood.organization_id) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 11 100 1=1 br.resource_code=:p_resource_code LOV custom Y select distinct br.resource_code value, br.description from mtl_parameters mp, bom_resources br where mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) ) and br.organization_id=mp.organization_id and br.cost_element_id in (3,4) and br.functional_currency_flag<>1 and nvl(br.allow_costs_flag,1)=1 and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code US Resource 12 110 1=1 upper(br.resource_code) like upper(:p_resource_like) Char US Resource Like 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Number number Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 ROW_ID Char varchar2 Y 7 TARGET_COST_TYPE LOV custom varchar2 10 Y select cct.cost_type_id id, cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate+1)>sysdate and cct.allow_updates_flag=1 and cct.frozen_standard_flag<>1 and (cct.organization_id is null or cct.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) order by cct.cost_type :$flex$.target_cost_type Y Y 8 ORGANIZATION_CODE LOV custom varchar2 3 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and exists (select null from cst_cost_types cct where cct.cost_type=:$flex$.target_cost_type and nvl(cct.organization_id,ood.organization_id)=ood.organization_id) order by ood.organization_code Y Y 9 RESOURCE_CODE LOV custom varchar2 10 Y select br.resource_id id, br.resource_code value, br.description from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.cost_element_id in (3,4) and br.functional_currency_flag<>1 and nvl(br.allow_costs_flag,1)=1 and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code Y Y 10 RESOURCE_DESCRIPTION Char varchar2 240 select br.description from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code Y 11 UNIT_OF_MEASURE Char varchar2 3 select br.unit_of_measure from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code Y 12 COST_ELEMENT Char varchar2 80 select xxen_util.meaning(br.cost_element_id,'CST_COST_CODE_TYPE',700) from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and br.organization_id=mp.organization_id and br.resource_code=:$column$.resource_code Y 13 RESOURCE_RATE Number number Y 14 DELETE_RESOURCE_RATE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to delete the existing resource rate for this resource and cost type. Deletion is not allowed for frozen standard cost types or for cost types which do not allow updates. 15 ATTRIBUTE_CATEGORY LOV custom varchar2 30 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 16 RSC_RATE_ATTRIBUTE1 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE1' 17 RSC_RATE_ATTRIBUTE2 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE2' 18 RSC_RATE_ATTRIBUTE3 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE3' 19 RSC_RATE_ATTRIBUTE4 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE4' 20 RSC_RATE_ATTRIBUTE5 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE5' 21 RSC_RATE_ATTRIBUTE6 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE6' 22 RSC_RATE_ATTRIBUTE7 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE7' 23 RSC_RATE_ATTRIBUTE8 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE8' 24 RSC_RATE_ATTRIBUTE9 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE9' 25 RSC_RATE_ATTRIBUTE10 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE10' 26 RSC_RATE_ATTRIBUTE11 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE11' 27 RSC_RATE_ATTRIBUTE12 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE12' 28 RSC_RATE_ATTRIBUTE13 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE13' 29 RSC_RATE_ATTRIBUTE14 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE14' 30 RSC_RATE_ATTRIBUTE15 LOV custom varchar2 150 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 702, p_descriptive_flexfield_name => 'CST_RESOURCE_COSTS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.rsc_rate_attribute1, p_attribute2 => :$column$.rsc_rate_attribute2, p_attribute3 => :$column$.rsc_rate_attribute3, p_attribute4 => :$column$.rsc_rate_attribute4, p_attribute5 => :$column$.rsc_rate_attribute5, p_attribute6 => :$column$.rsc_rate_attribute6, p_attribute7 => :$column$.rsc_rate_attribute7, p_attribute8 => :$column$.rsc_rate_attribute8, p_attribute9 => :$column$.rsc_rate_attribute9, p_attribute10 => :$column$.rsc_rate_attribute10, p_attribute11 => :$column$.rsc_rate_attribute11, p_attribute12 => :$column$.rsc_rate_attribute12, p_attribute13 => :$column$.rsc_rate_attribute13, p_attribute14 => :$column$.rsc_rate_attribute14, p_attribute15 => :$column$.rsc_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_RESOURCE_COSTS' and fdfcuv.application_column_name='ATTRIBUTE15' 31 PROCESS_FLAG Number number 1 Y 32 IMPORT_COST_OPTION Number number 2 Y Y 33 UPLOAD_MODE Char varchar2 2000 :$flex$.mode Y Y 34 ROLLUP_COSTS Char varchar2 2000 :$flex$.rollup_costs Y Y 35 ROLLUP_TYPE Char varchar2 2000 :$flex$.rollup_type Y Y 36 ROLLUP_OPTION Char varchar2 2000 :$flex$.rollup_option Y Y 37 ROLLUP_UNIMPL_ECOS Char varchar2 2000 Y 38 UPLOAD_ROW Number number Y U 1 p_resource_id in Number RESOURCE_CODE U 2 p_resource_code in Char RESOURCE_CODE value U 3 p_cost_type_id in Number TARGET_COST_TYPE U 4 p_cost_type in Char TARGET_COST_TYPE value U 5 p_organization_code in Char ORGANIZATION_CODE U 6 p_process_flag in Number PROCESS_FLAG U 7 p_resource_rate in Number RESOURCE_RATE U 8 p_delete_resource_rate in Char Y DELETE_RESOURCE_RATE U 9 p_attribute_category in Char ATTRIBUTE_CATEGORY U 10 p_attribute1 in Char RSC_RATE_ATTRIBUTE1 U 11 p_attribute2 in Char RSC_RATE_ATTRIBUTE2 U 12 p_attribute3 in Char RSC_RATE_ATTRIBUTE3 U 13 p_attribute4 in Char RSC_RATE_ATTRIBUTE4 U 14 p_attribute5 in Char RSC_RATE_ATTRIBUTE5 U 15 p_attribute6 in Char RSC_RATE_ATTRIBUTE6 U 16 p_attribute7 in Char RSC_RATE_ATTRIBUTE7 U 17 p_attribute8 in Char RSC_RATE_ATTRIBUTE8 U 18 p_attribute9 in Char RSC_RATE_ATTRIBUTE9 U 19 p_attribute10 in Char RSC_RATE_ATTRIBUTE10 U 20 p_attribute11 in Char RSC_RATE_ATTRIBUTE11 U 21 p_attribute12 in Char RSC_RATE_ATTRIBUTE12 U 22 p_attribute13 in Char RSC_RATE_ATTRIBUTE13 U 23 p_attribute14 in Char RSC_RATE_ATTRIBUTE14 U 24 p_attribute15 in Char RSC_RATE_ATTRIBUTE15 U 25 p_row_id in/out Char ROW_ID U 26 request_id_ out Number REQUEST_ID_ U 27 status_ out Char STATUS_CODE_ U 28 message_ out Char MESSAGE_ P 1 p_cost_type in Char TARGET_COST_TYPE value P 2 p_upload_mode in Number UPLOAD_MODE P 3 p_do_cost_rollup in Char Y ROLLUP_COSTS P 4 p_rollup_range in Number Y ROLLUP_TYPE P 5 p_rollup_option in Number Y ROLLUP_OPTION P 6 p_rollup_inc_unimp_ecn_flag in Number Y ROLLUP_UNIMPL_ECOS P 7 p_import_cost_option in Number Y IMPORT_COST_OPTION P 8 request_id_ out Number REQUEST_ID_ P 9 status_ out Char STATUS_CODE_ P 10 message_ out Char MESSAGE_ Error SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, case when crci.error_flag='E' then crci.error_explanation else nvl(xu.message_,'Post-Processing Error') end message_, xu.request_id_, xu.modified_columns_, xu.row_id, xu.target_cost_type, xu.organization_code, nvl(crci.resource_code,xu.resource_code) resource_code, xu.resource_description, xu.unit_of_measure, xu.cost_element, nvl(crci.resource_rate,xu.resource_rate) resource_rate, xu.delete_resource_rate, xu.attribute_category, xu.rsc_rate_attribute1, xu.rsc_rate_attribute2, xu.rsc_rate_attribute3, xu.rsc_rate_attribute4, xu.rsc_rate_attribute5, xu.rsc_rate_attribute6, xu.rsc_rate_attribute7, xu.rsc_rate_attribute8, xu.rsc_rate_attribute9, xu.rsc_rate_attribute10, xu.rsc_rate_attribute11, xu.rsc_rate_attribute12, xu.rsc_rate_attribute13, xu.rsc_rate_attribute14, xu.rsc_rate_attribute15, xu.process_flag, xu.import_cost_option, xu.upload_mode, xu.rollup_costs, xu.rollup_type, xu.rollup_option, xu.rollup_unimpl_ecos, xu.upload_row from xxen_cst_resource_rate_7053_u xu, cst_resource_costs_interface crci where chartorowid(xu.row_id)=crci.rowid(+) and crci.error_flag(+)='E' and (xu.status_code_=xxen_upload.status_error or crci.error_flag='E') Order By x.upload_row, x.target_cost_type, x.organization_code, x.resource_code Success SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, case when xu.delete_resource_rate is not null then 'Resource rate deleted.' else xu.message_ end message_, xu.request_id_, xu.modified_columns_, null row_id, cct_t.cost_type target_cost_type, mp.organization_code, br.resource_code, br.description resource_description, br.unit_of_measure, xxen_util.meaning(br.cost_element_id,'CST_COST_CODE_TYPE',700) cost_element, nvl(crc.resource_rate,xu.resource_rate) resource_rate, xu.delete_resource_rate, nvl(xxen_util.display_flexfield_context(702,'CST_RESOURCE_COSTS',crc.attribute_category),xu.attribute_category) attribute_category, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE1',crc.rowid,crc.attribute1),xu.rsc_rate_attribute1) rsc_rate_attribute1, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE2',crc.rowid,crc.attribute2),xu.rsc_rate_attribute2) rsc_rate_attribute2, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE3',crc.rowid,crc.attribute3),xu.rsc_rate_attribute3) rsc_rate_attribute3, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE4',crc.rowid,crc.attribute4),xu.rsc_rate_attribute4) rsc_rate_attribute4, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE5',crc.rowid,crc.attribute5),xu.rsc_rate_attribute5) rsc_rate_attribute5, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE6',crc.rowid,crc.attribute6),xu.rsc_rate_attribute6) rsc_rate_attribute6, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE7',crc.rowid,crc.attribute7),xu.rsc_rate_attribute7) rsc_rate_attribute7, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE8',crc.rowid,crc.attribute8),xu.rsc_rate_attribute8) rsc_rate_attribute8, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE9',crc.rowid,crc.attribute9),xu.rsc_rate_attribute9) rsc_rate_attribute9, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE10',crc.rowid,crc.attribute10),xu.rsc_rate_attribute10) rsc_rate_attribute10, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE11',crc.rowid,crc.attribute11),xu.rsc_rate_attribute11) rsc_rate_attribute11, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE12',crc.rowid,crc.attribute12),xu.rsc_rate_attribute12) rsc_rate_attribute12, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE13',crc.rowid,crc.attribute13),xu.rsc_rate_attribute13) rsc_rate_attribute13, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE14',crc.rowid,crc.attribute14),xu.rsc_rate_attribute14) rsc_rate_attribute14, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_COSTS',crc.attribute_category,'ATTRIBUTE15',crc.rowid,crc.attribute15),xu.rsc_rate_attribute15) rsc_rate_attribute15, xu.process_flag, xu.import_cost_option, xu.upload_mode, xu.rollup_costs, xu.rollup_type, xu.rollup_option, xu.rollup_unimpl_ecos, xu.upload_row from xxen_cst_resource_rate_7053_u xu, cst_cost_types cct_t, mtl_parameters mp, bom_resources br, cst_resource_costs crc where xu.status_code_=xxen_upload.status_success and (xu.row_id is null or xu.row_id not in (select rowidtochar(crci.rowid) from cst_resource_costs_interface crci where crci.error_flag='E')) and cct_t.cost_type=xu.target_cost_type and mp.organization_code=xu.organization_code and br.organization_id=mp.organization_id and br.resource_code=xu.resource_code and br.organization_id=crc.organization_id(+) and br.resource_id=crc.resource_id(+) and cct_t.cost_type_id=crc.cost_type_id(+)