ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CD1A780E55BF4D21BBD15ADAE16E3001Y select null action_, null status_, null message_, null modified_columns_, wci.container_item_id orig_container_item_id, wci.load_item_id orig_load_item_id, mp.organization_code, msiv_c.concatenated_segments container_item, xxen_util.meaning(msiv_c.container_type_code,'CONTAINER_TYPE',3) container_type, msiv_l.concatenated_segments load_item, msiv_l.primary_uom_code uom, wci.max_load_quantity maximum_quantity, xxen_util.yes(wci.preferred_flag) preferred_flag, null delete_relationship, msiv_c.description container_description, msiv_l.description load_description, xxen_util.display_flexfield_context(665,'WSH_CONTAINER_ITEMS',wci.attribute_category) attribute_category, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE1',wci.rowid,wci.attribute1) ci_attribute1, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE2',wci.rowid,wci.attribute2) ci_attribute2, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE3',wci.rowid,wci.attribute3) ci_attribute3, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE4',wci.rowid,wci.attribute4) ci_attribute4, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE5',wci.rowid,wci.attribute5) ci_attribute5, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE6',wci.rowid,wci.attribute6) ci_attribute6, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE7',wci.rowid,wci.attribute7) ci_attribute7, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE8',wci.rowid,wci.attribute8) ci_attribute8, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE9',wci.rowid,wci.attribute9) ci_attribute9, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE10',wci.rowid,wci.attribute10) ci_attribute10, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE11',wci.rowid,wci.attribute11) ci_attribute11, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE12',wci.rowid,wci.attribute12) ci_attribute12, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE13',wci.rowid,wci.attribute13) ci_attribute13, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE14',wci.rowid,wci.attribute14) ci_attribute14, xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE15',wci.rowid,wci.attribute15) ci_attribute15, to_number(null) upload_row from wsh_container_items wci, mtl_parameters mp, mtl_system_items_vl msiv_c, mtl_system_items_vl msiv_l where 1=1 and wci.master_organization_id=mp.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) and wci.master_organization_id=msiv_c.organization_id and wci.container_item_id=msiv_c.inventory_item_id and wci.master_organization_id=msiv_l.organization_id and wci.load_item_id=msiv_l.inventory_item_id Initial version. Creates, updates and deletes container-item relationships (wsh_container_items), replicating the Container-Item Relationships form (WSHFCNIR). U A xxen_wsh_upload.upload_container_item xxen_wsh_upload.validate_container_item(:$column$.organization_code,:$column$.container_item,:$column$.load_item,:$column$.maximum_quantity) US WSH Container Items Upload Creates, updates and deletes container-item relationships - the Container-Item Relationships form (Shipping > Setup > Container Load Details). A relationship states the maximum quantity of a load item that fits into a container item in one inventory organization; auto-pack uses the load item's preferred container. Setting Preferred Flag to Yes removes the flag from the load item's current preferred container, as the form does after asking, and the Message names that container. When several rows of one file make different containers preferred for the same load item, the last row wins. Maximum Quantity is rounded to five decimals and must be a whole number for serial controlled and indivisible load items. Changing the Container Item or Load Item of a downloaded row moves that relationship. To remove a relationship, enter Yes in Delete Relationship. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update 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 Create downloads an empty template. Create, Update also downloads the existing relationships. 2 20 1=1 mp.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 select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code Inventory organization of the relationships. Also the default Organization Code of new rows. 3 30 1=1 msiv_c.container_type_code=:container_type LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='CONTAINER_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning US Container Type Downloads only relationships whose container item has this container type. 4 40 1=1 msiv_c.concatenated_segments=:container_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 Container Item Downloads only relationships of this container item. 5 50 1=1 msiv_l.concatenated_segments=:load_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 Load Item Downloads only relationships of this load item. 6 60 1=1 wci.preferred_flag=:preferred_flag LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Preferred Flag Yes downloads only the preferred container of each load item. 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORIG_CONTAINER_ITEM_ID Number number Y 6 ORIG_LOAD_ITEM_ID Number number Y 7 ORGANIZATION_CODE LOV varchar2 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 select mp.organization_id id, mp.organization_code value from mtl_parameters mp where 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) :$flex$.organization_code Y Y 8 CONTAINER_ITEM LOV custom varchar2 Y Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.container_item_flag='Y' order by msiv.concatenated_segments select msiv.inventory_item_id id, msiv.concatenated_segments value from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id Y 9 CONTAINER_TYPE Char varchar2 select xxen_util.meaning(msiv.container_type_code,'CONTAINER_TYPE',3) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.container_item Y 10 LOAD_ITEM LOV custom varchar2 Y Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id order by msiv.concatenated_segments Y 11 UOM Char varchar2 select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.load_item Y 12 MAXIMUM_QUANTITY Number number Y 13 PREFERRED_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 14 DELETE_RELATIONSHIP LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where exists ( select null from mtl_parameters mp, mtl_system_items_vl msiv_c, mtl_system_items_vl msiv_l, wsh_container_items wci where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv_c.organization_id and msiv_c.concatenated_segments=:$column$.container_item and mp.organization_id=msiv_l.organization_id and msiv_l.concatenated_segments=:$column$.load_item and mp.organization_id=wci.master_organization_id and msiv_c.inventory_item_id=wci.container_item_id and msiv_l.inventory_item_id=wci.load_item_id ) 15 CONTAINER_DESCRIPTION Char varchar2 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.container_item Y 16 LOAD_DESCRIPTION Char varchar2 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.load_item Y 17 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=665 and fdfcv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 18 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE1' 19 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE2' 20 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE3' 21 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE4' 22 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE5' 23 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE6' 24 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE7' 25 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE8' 26 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE9' 27 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE10' 28 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE11' 29 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE12' 30 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE13' 31 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE14' 32 CI_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=>665, p_descriptive_flexfield_name=>'WSH_CONTAINER_ITEMS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.ci_attribute1, p_attribute2=>:$column$.ci_attribute2, p_attribute3=>:$column$.ci_attribute3, p_attribute4=>:$column$.ci_attribute4, p_attribute5=>:$column$.ci_attribute5, p_attribute6=>:$column$.ci_attribute6, p_attribute7=>:$column$.ci_attribute7, p_attribute8=>:$column$.ci_attribute8, p_attribute9=>:$column$.ci_attribute9, p_attribute10=>:$column$.ci_attribute10, p_attribute11=>:$column$.ci_attribute11, p_attribute12=>:$column$.ci_attribute12, p_attribute13=>:$column$.ci_attribute13, p_attribute14=>:$column$.ci_attribute14, p_attribute15=>:$column$.ci_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=665 and fdfv.descriptive_flexfield_name='WSH_CONTAINER_ITEMS' and 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 fdfcuv.application_column_name='ATTRIBUTE15' 33 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 p_organization_id in Number ORGANIZATION_CODE U 5 p_container_item_id in Number CONTAINER_ITEM U 6 p_load_item_id in Number LOAD_ITEM U 7 p_maximum_quantity in Number MAXIMUM_QUANTITY U 8 p_preferred_flag in Char Y PREFERRED_FLAG U 9 p_ci_attribute_category in Char Y ATTRIBUTE_CATEGORY U 10 p_ci_attribute1 in Char Y CI_ATTRIBUTE1 U 11 p_ci_attribute2 in Char Y CI_ATTRIBUTE2 U 12 p_ci_attribute3 in Char Y CI_ATTRIBUTE3 U 13 p_ci_attribute4 in Char Y CI_ATTRIBUTE4 U 14 p_ci_attribute5 in Char Y CI_ATTRIBUTE5 U 15 p_ci_attribute6 in Char Y CI_ATTRIBUTE6 U 16 p_ci_attribute7 in Char Y CI_ATTRIBUTE7 U 17 p_ci_attribute8 in Char Y CI_ATTRIBUTE8 U 18 p_ci_attribute9 in Char Y CI_ATTRIBUTE9 U 19 p_ci_attribute10 in Char Y CI_ATTRIBUTE10 U 20 p_ci_attribute11 in Char Y CI_ATTRIBUTE11 U 21 p_ci_attribute12 in Char Y CI_ATTRIBUTE12 U 22 p_ci_attribute13 in Char Y CI_ATTRIBUTE13 U 23 p_ci_attribute14 in Char Y CI_ATTRIBUTE14 U 24 p_ci_attribute15 in Char Y CI_ATTRIBUTE15 U 25 p_delete_relationship in Char Y DELETE_RELATIONSHIP U 26 p_orig_container_item_id in Number Y ORIG_CONTAINER_ITEM_ID U 27 p_orig_load_item_id in Number Y ORIG_LOAD_ITEM_ID Error SQL Order By upload_row, organization_code, container_item, load_item Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, wci.container_item_id orig_container_item_id, wci.load_item_id orig_load_item_id, nvl(mp.organization_code,xu.organization_code) organization_code, nvl(msiv_c.concatenated_segments,xu.container_item) container_item, nvl(xxen_util.meaning(msiv_c.container_type_code,'CONTAINER_TYPE',3),xu.container_type) container_type, nvl(msiv_l.concatenated_segments,xu.load_item) load_item, nvl(msiv_l.primary_uom_code,xu.uom) uom, nvl(wci.max_load_quantity,xu.maximum_quantity) maximum_quantity, case when wci.rowid is null then xu.preferred_flag else xxen_util.yes(wci.preferred_flag) end preferred_flag, xu.delete_relationship, nvl(msiv_c.description,xu.container_description) container_description, nvl(msiv_l.description,xu.load_description) load_description, case when wci.rowid is null then xu.attribute_category else xxen_util.display_flexfield_context(665,'WSH_CONTAINER_ITEMS',wci.attribute_category) end attribute_category, case when wci.rowid is null then xu.ci_attribute1 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE1',wci.rowid,wci.attribute1) end ci_attribute1, case when wci.rowid is null then xu.ci_attribute2 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE2',wci.rowid,wci.attribute2) end ci_attribute2, case when wci.rowid is null then xu.ci_attribute3 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE3',wci.rowid,wci.attribute3) end ci_attribute3, case when wci.rowid is null then xu.ci_attribute4 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE4',wci.rowid,wci.attribute4) end ci_attribute4, case when wci.rowid is null then xu.ci_attribute5 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE5',wci.rowid,wci.attribute5) end ci_attribute5, case when wci.rowid is null then xu.ci_attribute6 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE6',wci.rowid,wci.attribute6) end ci_attribute6, case when wci.rowid is null then xu.ci_attribute7 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE7',wci.rowid,wci.attribute7) end ci_attribute7, case when wci.rowid is null then xu.ci_attribute8 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE8',wci.rowid,wci.attribute8) end ci_attribute8, case when wci.rowid is null then xu.ci_attribute9 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE9',wci.rowid,wci.attribute9) end ci_attribute9, case when wci.rowid is null then xu.ci_attribute10 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE10',wci.rowid,wci.attribute10) end ci_attribute10, case when wci.rowid is null then xu.ci_attribute11 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE11',wci.rowid,wci.attribute11) end ci_attribute11, case when wci.rowid is null then xu.ci_attribute12 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE12',wci.rowid,wci.attribute12) end ci_attribute12, case when wci.rowid is null then xu.ci_attribute13 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE13',wci.rowid,wci.attribute13) end ci_attribute13, case when wci.rowid is null then xu.ci_attribute14 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE14',wci.rowid,wci.attribute14) end ci_attribute14, case when wci.rowid is null then xu.ci_attribute15 else xxen_util.display_flexfield_value(665,'WSH_CONTAINER_ITEMS',wci.attribute_category,'ATTRIBUTE15',wci.rowid,wci.attribute15) end ci_attribute15, xu.upload_row from ( select x.*, (select mp0.organization_id from mtl_parameters mp0 where x.organization_code=mp0.organization_code) organization_id, (select msiv0.inventory_item_id from mtl_parameters mp0, mtl_system_items_vl msiv0 where x.organization_code=mp0.organization_code and mp0.organization_id=msiv0.organization_id and x.container_item=msiv0.concatenated_segments) container_item_id, (select msiv0.inventory_item_id from mtl_parameters mp0, mtl_system_items_vl msiv0 where x.organization_code=mp0.organization_code and mp0.organization_id=msiv0.organization_id and x.load_item=msiv0.concatenated_segments) load_item_id from xxen_wsh_container_item_0116_u x ) xu, --before 12c an outer joined table may reference at most one other table, so the ids are resolved inside the view mtl_parameters mp, mtl_system_items_vl msiv_c, mtl_system_items_vl msiv_l, wsh_container_items wci where xu.status_code_=xxen_upload.status_success and xu.organization_id=mp.organization_id(+) and xu.organization_id=msiv_c.organization_id(+) and xu.container_item_id=msiv_c.inventory_item_id(+) and xu.organization_id=msiv_l.organization_id(+) and xu.load_item_id=msiv_l.inventory_item_id(+) and xu.organization_id=wci.master_organization_id(+) and xu.container_item_id=wci.container_item_id(+) and xu.load_item_id=wci.load_item_id(+)