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 A7C38C96D2344C7D94D3E41D7CE71D2FY 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_r.resource_code, br_r.description resource_description, br_o.resource_code overhead, br_o.description overhead_description, null delete_association, xxen_util.display_flexfield_context(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category) attribute_category, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE1',cro.rowid,cro.attribute1) res_ovhd_attribute1, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE2',cro.rowid,cro.attribute2) res_ovhd_attribute2, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE3',cro.rowid,cro.attribute3) res_ovhd_attribute3, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE4',cro.rowid,cro.attribute4) res_ovhd_attribute4, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE5',cro.rowid,cro.attribute5) res_ovhd_attribute5, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE6',cro.rowid,cro.attribute6) res_ovhd_attribute6, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE7',cro.rowid,cro.attribute7) res_ovhd_attribute7, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE8',cro.rowid,cro.attribute8) res_ovhd_attribute8, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE9',cro.rowid,cro.attribute9) res_ovhd_attribute9, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE10',cro.rowid,cro.attribute10) res_ovhd_attribute10, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE11',cro.rowid,cro.attribute11) res_ovhd_attribute11, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE12',cro.rowid,cro.attribute12) res_ovhd_attribute12, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE13',cro.rowid,cro.attribute13) res_ovhd_attribute13, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE14',cro.rowid,cro.attribute14) res_ovhd_attribute14, xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE15',cro.rowid,cro.attribute15) res_ovhd_attribute15, 1 process_flag, 3 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, cst_resource_overheads cro, bom_resources br_r, bom_resources br_o 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 cro.cost_type_id=cct_s.cost_type_id and cro.organization_id=mp.organization_id and cro.resource_id=br_r.resource_id and cro.overhead_id=br_o.resource_id 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_ovhd_interface xxen_cst_upload.submit_cost_import US CST Resource Overhead Association Upload CST Resource Overhead Association Upload ======================================== This upload can be used to - Upload new Resource Overhead Associations - Download the current Resource Overhead Associations for a Cost Type and upload them to a different Target Cost Type - Update the descriptive flexfield attributes of existing associations by re-uploading them in 'Remove and replace' mode - Delete existing Resource Overhead Associations Resource Overhead Associations link Resource or Outside Processing sub-elements to the Overhead or Material Overhead sub-elements they absorb. The associations are imported via the Oracle Cost Import Process. NOTE: You can only upload associations to cost types that are not flagged as frozen and are flagged as updateable. NOTE: The Cost Import Process cannot delete a Resource Overhead Association, so a row flagged for deletion is not sent to it. Set the Delete Association column to Yes and the association is removed directly when the row is processed, in the same way as the Overheads and Resources forms remove it. Deletion is not allowed for frozen standard cost types or for cost types which do not allow updates. Deleted associations 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 associations 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 use the associated resources - All items - the 'Supply Chain Cost Rollup - Print Report' concurrent request is submitted to rollup all items within each organization associations 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 associated resource - use 'All items' mode for those. Parameters ========== Target Cost Type (Required) - The Cost Type to which the Resource Overhead Associations are to be uploaded. Mode (Required, Default: Remove and replace cost information) - - Remove and replace cost information: an existing association for the same resource, overhead, and cost type is replaced - Insert new Cost Information Only: uploading an association that already exists raises an error Auto Populate Upload Columns (Default: Yes) - Applies to downloaded associations 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 Overhead Associations, to copy them to a different Target Cost Type. New associations can be entered as additional rows in the generated Excel. Rollup Costs - set to Yes to do a cost rollup after the associations are imported Rollup Type - All items or Specific item Rollup Option - Single level rollup or Full cost rollup Organization Code / Resource / Overhead - Optionally restrict the associations to be downloaded. Notes on the Upload =================== The upload supports the Resource Overhead 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_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_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 overhead associations are imported. 7 60 :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 associated 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 use the associated resources. 8 70 :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 9 80 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 10 90 1=1 br_r.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 nvl(br.allow_costs_flag,1)=1 and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code US Resource 11 100 1=1 br_o.resource_code=:p_overhead 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 (5,2) and nvl(br.allow_costs_flag,1)=1 and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code US Overhead 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 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 OVERHEAD 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 (5,2) and nvl(br.allow_costs_flag,1)=1 and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code Y Y 12 OVERHEAD_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$.overhead Y 13 DELETE_ASSOCIATION 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 association of this overhead to this resource for the cost type. Deletion is not allowed for frozen standard cost types or for cost types which do not allow updates. 14 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_OVERHEADS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 15 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE1' 16 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE2' 17 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE3' 18 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE4' 19 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE5' 20 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE6' 21 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE7' 22 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE8' 23 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE9' 24 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE10' 25 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE11' 26 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE12' 27 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE13' 28 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE14' 29 RES_OVHD_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_OVERHEADS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.res_ovhd_attribute1, p_attribute2 => :$column$.res_ovhd_attribute2, p_attribute3 => :$column$.res_ovhd_attribute3, p_attribute4 => :$column$.res_ovhd_attribute4, p_attribute5 => :$column$.res_ovhd_attribute5, p_attribute6 => :$column$.res_ovhd_attribute6, p_attribute7 => :$column$.res_ovhd_attribute7, p_attribute8 => :$column$.res_ovhd_attribute8, p_attribute9 => :$column$.res_ovhd_attribute9, p_attribute10 => :$column$.res_ovhd_attribute10, p_attribute11 => :$column$.res_ovhd_attribute11, p_attribute12 => :$column$.res_ovhd_attribute12, p_attribute13 => :$column$.res_ovhd_attribute13, p_attribute14 => :$column$.res_ovhd_attribute14, p_attribute15 => :$column$.res_ovhd_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_OVERHEADS' and fdfcuv.application_column_name='ATTRIBUTE15' 30 PROCESS_FLAG Number number 1 Y 31 IMPORT_COST_OPTION Number number 3 Y Y 32 UPLOAD_MODE Char varchar2 2000 :$flex$.mode Y Y 33 ROLLUP_COSTS Char varchar2 2000 :$flex$.rollup_costs Y Y 34 ROLLUP_TYPE Char varchar2 2000 :$flex$.rollup_type Y Y 35 ROLLUP_OPTION Char varchar2 2000 :$flex$.rollup_option Y Y 36 ROLLUP_UNIMPL_ECOS Char varchar2 2000 Y 37 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_overhead_id in Number OVERHEAD U 7 p_overhead in Char OVERHEAD value U 8 p_delete_association in Char DELETE_ASSOCIATION U 9 p_process_flag in Number PROCESS_FLAG U 10 p_attribute_category in Char ATTRIBUTE_CATEGORY U 11 p_attribute1 in Char RES_OVHD_ATTRIBUTE1 U 12 p_attribute2 in Char RES_OVHD_ATTRIBUTE2 U 13 p_attribute3 in Char RES_OVHD_ATTRIBUTE3 U 14 p_attribute4 in Char RES_OVHD_ATTRIBUTE4 U 15 p_attribute5 in Char RES_OVHD_ATTRIBUTE5 U 16 p_attribute6 in Char RES_OVHD_ATTRIBUTE6 U 17 p_attribute7 in Char RES_OVHD_ATTRIBUTE7 U 18 p_attribute8 in Char RES_OVHD_ATTRIBUTE8 U 19 p_attribute9 in Char RES_OVHD_ATTRIBUTE9 U 20 p_attribute10 in Char RES_OVHD_ATTRIBUTE10 U 21 p_attribute11 in Char RES_OVHD_ATTRIBUTE11 U 22 p_attribute12 in Char RES_OVHD_ATTRIBUTE12 U 23 p_attribute13 in Char RES_OVHD_ATTRIBUTE13 U 24 p_attribute14 in Char RES_OVHD_ATTRIBUTE14 U 25 p_attribute15 in Char RES_OVHD_ATTRIBUTE15 U 26 p_row_id in/out Char ROW_ID U 27 request_id_ out Number REQUEST_ID_ U 28 status_ out Char STATUS_CODE_ U 29 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 croi.error_flag='E' then croi.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(croi.resource_code,xu.resource_code) resource_code, xu.resource_description, nvl(croi.overhead,xu.overhead) overhead, xu.overhead_description, xu.delete_association, xu.attribute_category, xu.res_ovhd_attribute1, xu.res_ovhd_attribute2, xu.res_ovhd_attribute3, xu.res_ovhd_attribute4, xu.res_ovhd_attribute5, xu.res_ovhd_attribute6, xu.res_ovhd_attribute7, xu.res_ovhd_attribute8, xu.res_ovhd_attribute9, xu.res_ovhd_attribute10, xu.res_ovhd_attribute11, xu.res_ovhd_attribute12, xu.res_ovhd_attribute13, xu.res_ovhd_attribute14, xu.res_ovhd_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_overh_5118_u xu, cst_res_overheads_interface croi where chartorowid(xu.row_id)=croi.rowid(+) and croi.error_flag(+)='E' and (xu.status_code_=xxen_upload.status_error or croi.error_flag='E') Order By x.upload_row, x.target_cost_type, x.organization_code, x.resource_code, x.overhead Success SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, case when xu.delete_association is not null then 'Resource overhead association deleted.' else xu.message_ end message_, xu.request_id_, xu.modified_columns_, null row_id, xu.target_cost_type, xu.organization_code, xu.resource_code, xu.resource_description, xu.overhead, xu.overhead_description, xu.delete_association, nvl(xxen_util.display_flexfield_context(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category),xu.attribute_category) attribute_category, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE1',cro.rowid,cro.attribute1),xu.res_ovhd_attribute1) res_ovhd_attribute1, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE2',cro.rowid,cro.attribute2),xu.res_ovhd_attribute2) res_ovhd_attribute2, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE3',cro.rowid,cro.attribute3),xu.res_ovhd_attribute3) res_ovhd_attribute3, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE4',cro.rowid,cro.attribute4),xu.res_ovhd_attribute4) res_ovhd_attribute4, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE5',cro.rowid,cro.attribute5),xu.res_ovhd_attribute5) res_ovhd_attribute5, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE6',cro.rowid,cro.attribute6),xu.res_ovhd_attribute6) res_ovhd_attribute6, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE7',cro.rowid,cro.attribute7),xu.res_ovhd_attribute7) res_ovhd_attribute7, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE8',cro.rowid,cro.attribute8),xu.res_ovhd_attribute8) res_ovhd_attribute8, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE9',cro.rowid,cro.attribute9),xu.res_ovhd_attribute9) res_ovhd_attribute9, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE10',cro.rowid,cro.attribute10),xu.res_ovhd_attribute10) res_ovhd_attribute10, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE11',cro.rowid,cro.attribute11),xu.res_ovhd_attribute11) res_ovhd_attribute11, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE12',cro.rowid,cro.attribute12),xu.res_ovhd_attribute12) res_ovhd_attribute12, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE13',cro.rowid,cro.attribute13),xu.res_ovhd_attribute13) res_ovhd_attribute13, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE14',cro.rowid,cro.attribute14),xu.res_ovhd_attribute14) res_ovhd_attribute14, nvl(xxen_util.display_flexfield_value(702,'CST_RESOURCE_OVERHEADS',cro.attribute_category,'ATTRIBUTE15',cro.rowid,cro.attribute15),xu.res_ovhd_attribute15) res_ovhd_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 ( select xu.action_, xu.message_, xu.request_id_, xu.modified_columns_, cct_t.cost_type target_cost_type, mp.organization_code, br_r.resource_code, br_r.description resource_description, br_o.resource_code overhead, br_o.description overhead_description, xu.delete_association, xu.attribute_category, xu.res_ovhd_attribute1, xu.res_ovhd_attribute2, xu.res_ovhd_attribute3, xu.res_ovhd_attribute4, xu.res_ovhd_attribute5, xu.res_ovhd_attribute6, xu.res_ovhd_attribute7, xu.res_ovhd_attribute8, xu.res_ovhd_attribute9, xu.res_ovhd_attribute10, xu.res_ovhd_attribute11, xu.res_ovhd_attribute12, xu.res_ovhd_attribute13, xu.res_ovhd_attribute14, xu.res_ovhd_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, mp.organization_id, br_r.resource_id, br_o.resource_id overhead_id, cct_t.cost_type_id from xxen_cst_resource_overh_5118_u xu, cst_cost_types cct_t, mtl_parameters mp, bom_resources br_r, bom_resources br_o where xu.status_code_=xxen_upload.status_success and (xu.row_id is null or xu.row_id not in (select rowidtochar(croi.rowid) from cst_res_overheads_interface croi where croi.error_flag='E')) and cct_t.cost_type=xu.target_cost_type and mp.organization_code=xu.organization_code and br_r.organization_id=mp.organization_id and br_r.resource_code=xu.resource_code and br_o.organization_id=mp.organization_id and br_o.resource_code=xu.overhead ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped cst_resource_overheads cro where xu.resource_id=cro.resource_id(+) and xu.overhead_id=cro.overhead_id(+) and xu.organization_id=cro.organization_id(+) and xu.cost_type_id=cro.cost_type_id(+)