ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDF0079D2E0530100007F1FF2 INV Cross Reference Y select mcrv.cross_reference value, mcrv.description from mtl_cross_references_vl mcrv where (mcrv.organization_id is null or :$flex$.organization_code is null or mcrv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.cross_reference_type is null or mcrv.cross_reference_type=:$flex$.cross_reference_type) order by mcrv.cross_reference US 8E2FF36EDEE479D2E0530100007F1FF2 INV Cross Reference Type Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 0B22DF18E239D64AE0630100007FBD85 INV Organization Code (including master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US All active inventory organization codes, restricted to the current user's org access view 7F3A1C42D9E84B15A0C36E2F8B47D913Y select null action_, null status_, null message_, to_number(null) request_id_, null modified_columns_, mcrv.cross_reference_id cross_reference_row_id, -- mp.organization_code item_master_org, msiv.concatenated_segments item, msiv.description item_description, mcrv.cross_reference_type, xxen_util.yes(mcrv.org_independent_flag) applicable_to_all_orgs, mp_xref.organization_code org, mir.revision, mcrv.uom_code unit_of_measure, mcrv.cross_reference, mcrv.description, null delete_cross_reference, -- xxen_util.display_flexfield_context(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category) xref_attribute_category, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE1',mcrv.rowid,mcrv.attribute1) xref_attribute1, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE2',mcrv.rowid,mcrv.attribute2) xref_attribute2, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE3',mcrv.rowid,mcrv.attribute3) xref_attribute3, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE4',mcrv.rowid,mcrv.attribute4) xref_attribute4, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE5',mcrv.rowid,mcrv.attribute5) xref_attribute5, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE6',mcrv.rowid,mcrv.attribute6) xref_attribute6, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE7',mcrv.rowid,mcrv.attribute7) xref_attribute7, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE8',mcrv.rowid,mcrv.attribute8) xref_attribute8, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE9',mcrv.rowid,mcrv.attribute9) xref_attribute9, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE10',mcrv.rowid,mcrv.attribute10) xref_attribute10, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE11',mcrv.rowid,mcrv.attribute11) xref_attribute11, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE12',mcrv.rowid,mcrv.attribute12) xref_attribute12, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE13',mcrv.rowid,mcrv.attribute13) xref_attribute13, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE14',mcrv.rowid,mcrv.attribute14) xref_attribute14, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE15',mcrv.rowid,mcrv.attribute15) xref_attribute15, to_number(null) upload_row from mtl_cross_references_vl mcrv, mtl_system_items_vl msiv, mtl_parameters mp, mtl_parameters mp_xref, mtl_item_revisions_b mir where mcrv.inventory_item_id=msiv.inventory_item_id and msiv.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id and mcrv.organization_id=mp_xref.organization_id(+) and mcrv.revision_id=mir.revision_id(+) 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 :p_upload_mode like '%'||xxen_upload.action_update and 1=1 Initial version. Creates, updates and deletes item cross references (mtl_cross_references) through the public API mtl_cross_references_pub.process_xref, replicating the Item Cross Reference Assignment window of the Cross Reference Types form (INVIDXRT). U A xxen_inv_upload.upload_item_cross_reference xxen_inv_upload.validate_item_xref_row(:$column$.cross_reference_type,:$column$.applicable_to_all_orgs,:$column$.org,:$column$.revision,:$column$.unit_of_measure) US INV Item Cross Reference Upload Creates, updates and deletes item cross references - the Cross Reference Types form (Inventory > Setup > Items > Cross-Reference Types), also reached from the Item form via Tools > Cross References. A cross reference is either organization independent (Applicable To All Organizations is set and Org is blank) or specific to one organization (Org is entered). The organization must be one the item is assigned to. Revision and Unit of Measure only apply to the GTIN cross reference type named by the profile option INV: GTIN Cross Reference Type, and Revision additionally requires an organization. Entering them for any other type is rejected. Descriptions are translatable and are downloaded in the session language. To remove a cross reference, enter Yes in Delete Cross Reference on a downloaded row. Enginatics Upload 1=1 :p_upload_mode 1 10 :p_upload_mode LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 msiv.concatenated_segments=:item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Item 3 30 1=1 mcrv.cross_reference_type=:cross_reference_type LOV INV Cross Reference Type 8E2FF36EDEE479D2E0530100007F1FF2 Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type US Cross Reference Type 4 40 1=1 mcrv.cross_reference=:cross_reference LOV INV Cross Reference 8E2FF36EDF0079D2E0530100007F1FF2 Y select mcrv.cross_reference value, mcrv.description from mtl_cross_references_vl mcrv where (mcrv.organization_id is null or :$flex$.organization_code is null or mcrv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.cross_reference_type is null or mcrv.cross_reference_type=:$flex$.cross_reference_type) order by mcrv.cross_reference US Cross Reference 5 50 1=1 mp_xref.organization_code=:organization_code LOV INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US Organization Code 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 CROSS_REFERENCE_ROW_ID Number number Y 7 ITEM_MASTER_ORG LOV custom varchar2 Y select mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id=haouv.organization_id and mp.organization_id=mp.master_organization_id 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) order by mp.organization_code select mp2.organization_code from mtl_parameters mp, mtl_parameters mp2 where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and mp.master_organization_id=mp2.organization_id Y 8 ITEM LOV custom varchar2 Y Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id and mp.organization_code=:$column$.item_master_org order by msiv.concatenated_segments Y 9 ITEM_DESCRIPTION Char varchar2 select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id and mp.organization_code=:$column$.item_master_org and msiv.concatenated_segments=:$column$.item Y 10 CROSS_REFERENCE_TYPE LOV varchar2 INV Cross Reference Type 8E2FF36EDEE479D2E0530100007F1FF2 Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type Y 11 APPLICABLE_TO_ALL_ORGS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 12 ORG LOV custom varchar2 Y select mp.organization_id id, mp.organization_code value, haouv.name description from mtl_system_items_b msib, mtl_parameters mp, hr_all_organization_units_vl haouv where msib.organization_id=mp.organization_id and mp.organization_id=haouv.organization_id and msib.inventory_item_id=(select msiv2.inventory_item_id from mtl_system_items_vl msiv2, mtl_parameters mp2 where msiv2.organization_id=mp2.organization_id and mp2.organization_id=mp2.master_organization_id and mp2.organization_code=:$column$.item_master_org and msiv2.concatenated_segments=:$column$.item) 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) order by mp.organization_code 13 REVISION LOV custom varchar2 Y select mirv.revision_id id, mirv.revision value, mirv.description from mtl_item_revisions_vl mirv, mtl_parameters mp where mirv.organization_id=mp.organization_id and mirv.inventory_item_id=(select msiv2.inventory_item_id from mtl_system_items_vl msiv2, mtl_parameters mp2 where msiv2.organization_id=mp2.organization_id and mp2.organization_id=mp2.master_organization_id and mp2.organization_code=:$column$.item_master_org and msiv2.concatenated_segments=:$column$.item) and mp.organization_code=:$column$.org order by mirv.revision 14 UNIT_OF_MEASURE LOV custom varchar2 Y select muomv.uom_code id, muomv.unit_of_measure value, muomv.description from mtl_units_of_measure_vl muomv where muomv.uom_code in ( select muc.uom_code from mtl_uom_conversions muc where muc.inventory_item_id=(select msiv2.inventory_item_id from mtl_system_items_vl msiv2, mtl_parameters mp2 where msiv2.organization_id=mp2.organization_id and mp2.organization_id=mp2.master_organization_id and mp2.organization_code=:$column$.item_master_org and msiv2.concatenated_segments=:$column$.item) union all select muc2.uom_code from mtl_uom_conversions muc2 where muc2.inventory_item_id=0 ) order by muomv.unit_of_measure 15 CROSS_REFERENCE Char varchar2 Y 16 DESCRIPTION Char varchar2 17 DELETE_CROSS_REFERENCE LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.cross_reference_row_id is not null 18 XREF_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, null description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 19 XREF_ATTRIBUTE1 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 20 XREF_ATTRIBUTE2 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 21 XREF_ATTRIBUTE3 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 22 XREF_ATTRIBUTE4 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 23 XREF_ATTRIBUTE5 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 24 XREF_ATTRIBUTE6 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 25 XREF_ATTRIBUTE7 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 26 XREF_ATTRIBUTE8 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 27 XREF_ATTRIBUTE9 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 28 XREF_ATTRIBUTE10 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 29 XREF_ATTRIBUTE11 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 30 XREF_ATTRIBUTE12 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 31 XREF_ATTRIBUTE13 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 32 XREF_ATTRIBUTE14 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 33 XREF_ATTRIBUTE15 LOV custom varchar2 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=>401, p_descriptive_flexfield_name=>'MTL_CROSS_REFERENCES', p_context_name=>:$column$.xref_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.xref_attribute1, p_attribute2=>:$column$.xref_attribute2, p_attribute3=>:$column$.xref_attribute3, p_attribute4=>:$column$.xref_attribute4, p_attribute5=>:$column$.xref_attribute5, p_attribute6=>:$column$.xref_attribute6, p_attribute7=>:$column$.xref_attribute7, p_attribute8=>:$column$.xref_attribute8, p_attribute9=>:$column$.xref_attribute9, p_attribute10=>:$column$.xref_attribute10, p_attribute11=>:$column$.xref_attribute11, p_attribute12=>:$column$.xref_attribute12, p_attribute13=>:$column$.xref_attribute13, p_attribute14=>:$column$.xref_attribute14, p_attribute15=>:$column$.xref_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 fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_CROSS_REFERENCES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 34 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_cross_reference_row_id in/out Number CROSS_REFERENCE_ROW_ID U 6 p_item in Number Y ITEM U 7 p_cross_reference_type in Char Y CROSS_REFERENCE_TYPE U 8 p_applicable_to_all_orgs in Char Y APPLICABLE_TO_ALL_ORGS U 9 p_org in Number Y ORG U 10 p_revision in Number Y REVISION U 11 p_unit_of_measure in Char Y UNIT_OF_MEASURE U 12 p_cross_reference in Char Y CROSS_REFERENCE U 13 p_description in Char Y DESCRIPTION U 14 p_delete_cross_reference in Char Y DELETE_CROSS_REFERENCE U 15 p_attribute_category in Char Y XREF_ATTRIBUTE_CATEGORY U 16 p_attribute1 in Char Y XREF_ATTRIBUTE1 U 17 p_attribute2 in Char Y XREF_ATTRIBUTE2 U 18 p_attribute3 in Char Y XREF_ATTRIBUTE3 U 19 p_attribute4 in Char Y XREF_ATTRIBUTE4 U 20 p_attribute5 in Char Y XREF_ATTRIBUTE5 U 21 p_attribute6 in Char Y XREF_ATTRIBUTE6 U 22 p_attribute7 in Char Y XREF_ATTRIBUTE7 U 23 p_attribute8 in Char Y XREF_ATTRIBUTE8 U 24 p_attribute9 in Char Y XREF_ATTRIBUTE9 U 25 p_attribute10 in Char Y XREF_ATTRIBUTE10 U 26 p_attribute11 in Char Y XREF_ATTRIBUTE11 U 27 p_attribute12 in Char Y XREF_ATTRIBUTE12 U 28 p_attribute13 in Char Y XREF_ATTRIBUTE13 U 29 p_attribute14 in Char Y XREF_ATTRIBUTE14 U 30 p_attribute15 in Char Y XREF_ATTRIBUTE15 Error SQL Order By upload_row, item, cross_reference_type, cross_reference Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.cross_reference_row_id, -- nvl((select mp.organization_code from mtl_system_items_b msib, mtl_parameters mp where mcrv.inventory_item_id=msib.inventory_item_id and msib.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id),xu.item_master_org) item_master_org, nvl((select msiv.concatenated_segments from mtl_system_items_vl msiv, mtl_parameters mp where mcrv.inventory_item_id=msiv.inventory_item_id and msiv.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id),xu.item) item, nvl((select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where mcrv.inventory_item_id=msiv.inventory_item_id and msiv.organization_id=mp.organization_id and mp.organization_id=mp.master_organization_id),xu.item_description) item_description, nvl(mcrv.cross_reference_type,xu.cross_reference_type) cross_reference_type, nvl(xxen_util.yes(mcrv.org_independent_flag),xu.applicable_to_all_orgs) applicable_to_all_orgs, nvl(mp_xref.organization_code,xu.org) org, nvl(mir.revision,xu.revision) revision, nvl(mcrv.uom_code,xu.unit_of_measure) unit_of_measure, nvl(mcrv.cross_reference,xu.cross_reference) cross_reference, nvl(mcrv.description,xu.description) description, xu.delete_cross_reference, -- xxen_util.display_flexfield_context(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category) xref_attribute_category, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE1',mcrv.rowid,mcrv.attribute1) xref_attribute1, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE2',mcrv.rowid,mcrv.attribute2) xref_attribute2, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE3',mcrv.rowid,mcrv.attribute3) xref_attribute3, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE4',mcrv.rowid,mcrv.attribute4) xref_attribute4, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE5',mcrv.rowid,mcrv.attribute5) xref_attribute5, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE6',mcrv.rowid,mcrv.attribute6) xref_attribute6, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE7',mcrv.rowid,mcrv.attribute7) xref_attribute7, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE8',mcrv.rowid,mcrv.attribute8) xref_attribute8, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE9',mcrv.rowid,mcrv.attribute9) xref_attribute9, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE10',mcrv.rowid,mcrv.attribute10) xref_attribute10, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE11',mcrv.rowid,mcrv.attribute11) xref_attribute11, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE12',mcrv.rowid,mcrv.attribute12) xref_attribute12, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE13',mcrv.rowid,mcrv.attribute13) xref_attribute13, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE14',mcrv.rowid,mcrv.attribute14) xref_attribute14, xxen_util.display_flexfield_value(401,'MTL_CROSS_REFERENCES',mcrv.attribute_category,'ATTRIBUTE15',mcrv.rowid,mcrv.attribute15) xref_attribute15, xu.upload_row from xxen_inv_item_cross_ref_9860_u xu, mtl_cross_references_vl mcrv, mtl_parameters mp_xref, mtl_item_revisions_b mir where xu.status_code_=xxen_upload.status_success and xu.cross_reference_row_id=mcrv.cross_reference_id(+) and mcrv.organization_id=mp_xref.organization_id(+) and mcrv.revision_id=mir.revision_id(+)