ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 7A3F9C2E8B5D4612FE0F9A1D3B6C4E78Y select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, msiv.primary_uom_code uom, misi.secondary_inventory subinventory, msec.description subinventory_description, decode(misi.inventory_planning_code,2,xxen_util.meaning('Y','YES_NO',0)) min_max_planning, misi.min_minmax_quantity, misi.max_minmax_quantity, misi.fixed_lot_multiple, misi.minimum_order_quantity, misi.maximum_order_quantity, xxen_util.meaning(to_char(misi.source_type),'MTL_SOURCE_TYPES',700) source_type, mp_src.organization_code source_organization, misi.source_subinventory, misi.preprocessing_lead_time, misi.processing_lead_time, misi.postprocessing_lead_time, xxen_util.display_flexfield_context(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category) item_sub_attribute_category, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE1',misi.rowid,misi.attribute1) item_sub_attribute1, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE2',misi.rowid,misi.attribute2) item_sub_attribute2, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE3',misi.rowid,misi.attribute3) item_sub_attribute3, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE4',misi.rowid,misi.attribute4) item_sub_attribute4, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE5',misi.rowid,misi.attribute5) item_sub_attribute5, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE6',misi.rowid,misi.attribute6) item_sub_attribute6, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE7',misi.rowid,misi.attribute7) item_sub_attribute7, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE8',misi.rowid,misi.attribute8) item_sub_attribute8, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE9',misi.rowid,misi.attribute9) item_sub_attribute9, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE10',misi.rowid,misi.attribute10) item_sub_attribute10, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE11',misi.rowid,misi.attribute11) item_sub_attribute11, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE12',misi.rowid,misi.attribute12) item_sub_attribute12, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE13',misi.rowid,misi.attribute13) item_sub_attribute13, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE14',misi.rowid,misi.attribute14) item_sub_attribute14, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE15',misi.rowid,misi.attribute15) item_sub_attribute15, milk.concatenated_segments locator, milk.description locator_description, msl.maximum_quantity par_level, to_char(null) delete_option, (select sum(moqd.primary_transaction_quantity) from mtl_onhand_quantities_detail moqd where misi.organization_id=moqd.organization_id and misi.inventory_item_id=moqd.inventory_item_id and misi.secondary_inventory=moqd.subinventory_code) onhand_quantity, to_number(null) upload_row from mtl_item_sub_inventories misi, mtl_parameters mp, mtl_system_items_vl msiv, mtl_secondary_inventories msec, mtl_parameters mp_src, (select msl.* from mtl_secondary_locators msl where nvl(:p_download_locators,'N')='Y') msl, mtl_item_locations_kfv milk where 1=1 and mp.organization_id=misi.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 msiv.inventory_item_id=misi.inventory_item_id and msiv.organization_id=misi.organization_id and msec.organization_id=misi.organization_id and msec.secondary_inventory_name=misi.secondary_inventory and mp_src.organization_id(+)=misi.source_organization_id and msl.inventory_item_id(+)=misi.inventory_item_id and msl.organization_id(+)=misi.organization_id and msl.subinventory_code(+)=misi.secondary_inventory and milk.organization_id(+)=msl.organization_id and milk.subinventory_code(+)=msl.subinventory_code and milk.inventory_location_id(+)=msl.secondary_locator Added read-only column Onhand Quantity, parameter Min-Max Planned Only and templates Item Subinventory Min-Max and Item Locator Assignments. U A xxen_inv_upload.upload_item_subinventory US INV Item Subinventory Upload Create, update and delete item-to-subinventory assignments (plus their optional item-subinventory-locator ties) across accessible inventory organizations. Each row is one (Organization, Item, Subinventory, Locator?) combination. When the Locator column is blank, only the item-subinventory header is processed. When the Locator column is populated, the item-subinventory header (if not already processed in this run) AND the locator tie are processed. When multiple rows share the same Organization/Item/Subinventory triple, the header is processed only on the first row of the triple (siblings contribute only their locator portion); header cells on subsequent rows are silently ignored. Order data by Organization, Item, Subinventory, Locator to make sibling grouping deterministic. Subinventory selection is restricted to Storage subinventories (Receiving subinventories cannot hold item assignments). Download Locator Assignments controls whether the template pulls in existing locator ties. Choose Yes (the default) to see the current locator ties alongside each item-subinventory assignment. Leave blank to suppress them — useful when you only want to update item-subinventory header data without duplicated rows for each existing locator. Min-Max Planning is a Yes/No flag matching the form's Min-Max checkbox: Yes enables Min-Max planning (and makes Min Qty / Max Qty required); blank means Not Planned. This choice is independent of the subinventory's own planning level. PAR Level is only meaningful when the parent Subinventory has PAR Level planning enabled. If the Subinventory is not PAR-enabled, any PAR Level value supplied on the row is silently ignored on create, and any legacy stored value is cleared on update. Source Type drives the conditional requirement on Source Organization and Source Subinventory. Inventory and Subinventory source types require Source Organization; Subinventory source type additionally restricts Source Organization to the row's own organization (same-org self-sourcing only). Supplier and blank source types must leave both source fields blank. Delete Option lets you specify what to delete. Choose Subinventory to delete the item-subinventory assignment (cascades to all locator ties for that item-subinventory). Choose Locator to delete just the locator assignment on this row (only offered when Locator is populated). Once a row deletes an item-subinventory, any subsequent rows for the same Organization/Item/Subinventory triple are rejected with a clear error to prevent orphaned inserts on the deleted parent. Organization, Item, Subinventory and Locator are read-only on existing rows — to change a key column, delete the row and create a new one. Stock locators referenced here must already exist in the chosen Subinventory (use the INV Stock Locator Upload to create them). Enginatics R12 only Upload 1=1 :p_download_locators 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 Y US Upload Mode 2 20 1=1 mp.organization_code=:p_organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or not exists (select null from xxen_report_org_access xroa where xroa.access_type='INV') and ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) 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 and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) 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 3 30 1=1 misi.secondary_inventory=:p_subinventory LOV custom Y select msec.secondary_inventory_name value, msec.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msec where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msec.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 msec.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msec.subinventory_type=1 and msec.organization_id=mp.organization_id order by mp.organization_code, msec.secondary_inventory_name US Subinventory 4 40 1=1 msiv.concatenated_segments=:p_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 5 50 :p_download_locators LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Download Locators 6 60 1=1 misi.inventory_planning_code=2 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Min-Max Planned Only Item subinventories with min-max planning enabled. 716822A12F2A476AA68BC1BF7188645A Default All columns except the descriptive flexfield attributes. ENGINATICS 22 DELETE_OPTION 10 FIXED_LOT_MULTIPLE 2 ITEM 3 ITEM_DESCRIPTION 19 LOCATOR 20 LOCATOR_DESCRIPTION 12 MAXIMUM_ORDER_QUANTITY 9 MAX_MINMAX_QUANTITY 11 MINIMUM_ORDER_QUANTITY 7 MIN_MAX_PLANNING 8 MIN_MINMAX_QUANTITY 1 ORGANIZATION_CODE 21 PAR_LEVEL 18 POSTPROCESSING_LEAD_TIME 16 PREPROCESSING_LEAD_TIME 17 PROCESSING_LEAD_TIME 14 SOURCE_ORGANIZATION 15 SOURCE_SUBINVENTORY 13 SOURCE_TYPE 5 SUBINVENTORY 6 SUBINVENTORY_DESCRIPTION 4 UOM Y S Site 9EFBE68015644D3FA0070724BA058B14 Item Locator Assignments Item locator assignments (restricted locators) within subinventories, with par level. Add or delete locator assignments or update the par level. ENGINATICS 2 ITEM 4 3 ITEM_DESCRIPTION 5 LOCATOR 3 6 LOCATOR_DESCRIPTION 1 ORGANIZATION_CODE 1 7 PAR_LEVEL 4 SUBINVENTORY 2 Download Locators Y Upload Mode C,U S Site 1 LOCATOR is not null 8AAE5AEA75844451ACB61064FA475DED Item Subinventory Min-Max Subinventory min-max planning levels of items against their on-hand quantity in the subinventory. Update the min-max quantities, order modifiers, sourcing and lead times. ENGINATICS 9 FIXED_LOT_MULTIPLE 2 ITEM 3 3 ITEM_DESCRIPTION 11 MAXIMUM_ORDER_QUANTITY 7 MAX_MINMAX_QUANTITY 10 MINIMUM_ORDER_QUANTITY 6 MIN_MINMAX_QUANTITY 8 ONHAND_QUANTITY 1 ORGANIZATION_CODE 1 17 POSTPROCESSING_LEAD_TIME 15 PREPROCESSING_LEAD_TIME 16 PROCESSING_LEAD_TIME 13 SOURCE_ORGANIZATION 14 SOURCE_SUBINVENTORY 12 SOURCE_TYPE 5 SUBINVENTORY 2 4 UOM Download Locators Min-Max Planned Only Y Upload Mode C,U S Site 716822A12F2A476AA68BC1BF7188645A 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORGANIZATION_CODE LOV varchar2 INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or not exists (select null from xxen_report_org_access xroa where xroa.access_type='INV') and ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) 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 and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_id id, mp.organization_code value from mtl_parameters mp :$flex$.organization_code Inventory organization for this item-subinventory assignment. Required. Cannot be changed for an existing assignment — delete and re-create to move an assignment to a different organization. Y Y 6 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 mp.organization_code=:$column$.organization_code and msiv.organization_id=mp.organization_id order by msiv.concatenated_segments Item assigned to the subinventory. Restricted to items enabled in the row's Organization. Required. Cannot be changed for an existing assignment. Y Y 7 ITEM_DESCRIPTION Char varchar2 select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where mp.organization_code=:$column$.organization_code and msiv.organization_id=mp.organization_id and msiv.concatenated_segments=:$column$.item Translated item description (read-only display). Y 8 UOM Char varchar2 select msiv.primary_uom_code from mtl_system_items_vl msiv, mtl_parameters mp where mp.organization_code=:$column$.organization_code and msiv.organization_id=mp.organization_id and msiv.concatenated_segments=:$column$.item Primary unit of measure of the item (read-only display). Y 9 SUBINVENTORY LOV custom varchar2 Y select msec.secondary_inventory_name value, msec.description from mtl_secondary_inventories msec, mtl_parameters mp where mp.organization_code=:$column$.organization_code and msec.organization_id=mp.organization_id and msec.subinventory_type=1 order by msec.secondary_inventory_name select :$flex$.Subinventory from dual Subinventory the item is assigned to. Restricted to subinventories of the row's Organization. Required. Cannot be changed for an existing assignment. Defaults from the Subinventory report parameter. Y Y 10 SUBINVENTORY_DESCRIPTION Char varchar2 select msec.description from mtl_secondary_inventories msec, mtl_parameters mp where mp.organization_code=:$column$.organization_code and msec.organization_id=mp.organization_id and msec.secondary_inventory_name=:$column$.subinventory Subinventory description (read-only display). Y 11 MIN_MAX_PLANNING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Enable Min-Max planning for this item in this subinventory (matches the form's Min-Max checkbox). Yes = Min-Max enabled (Min Qty and Max Qty required); blank = Not Planned. When the parent Subinventory is PAR-planned, the engine forces PAR planning regardless of this value. 12 MIN_MINMAX_QUANTITY Number number Minimum on-hand quantity for Min-Max planning. Required when Min-Max Planning is Yes. Must be greater than or equal to 0 and less than or equal to Max Qty. 13 MAX_MINMAX_QUANTITY Number number Maximum on-hand quantity for Min-Max planning. Required when Min-Max Planning is Yes. Must be greater than or equal to Min Qty. 14 FIXED_LOT_MULTIPLE Number number Fixed lot multiple for replenishment ordering. When entered, must be greater than 0. 15 MINIMUM_ORDER_QUANTITY Number number Minimum order quantity. When entered, must be greater than 0 and less than or equal to Maximum Order Quantity. 16 MAXIMUM_ORDER_QUANTITY Number number Maximum order quantity. When entered, must be greater than or equal to Minimum Order Quantity. 17 SOURCE_TYPE LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MTL_SOURCE_TYPES' and ml.enabled_flag='Y' order by ml.meaning Replenishment source type. Inventory = source from another inventory organization (Source Organization required); Supplier = external supplier (Source Organization and Source Subinventory must be blank); Subinventory = same-organization self-sourcing (Source Organization must equal this row's Organization). Blank = no replenishment source defined. 18 SOURCE_ORGANIZATION LOV custom varchar2 Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood, mtl_parameters mp where mp.organization_code=:$column$.organization_code and nvl(ood.disable_date,sysdate+1)>sysdate and nvl(ood.user_definition_enable_date,sysdate)<=sysdate and ( (xxen_util.lookup_code(:$column$.source_type,'MTL_SOURCE_TYPES',700)=1 and (ood.organization_id in (select miop.from_organization_id from mtl_interorg_parameters miop where miop.to_organization_id=mp.organization_id) or ood.organization_id=mp.organization_id)) or (xxen_util.lookup_code(:$column$.source_type,'MTL_SOURCE_TYPES',700)=3 and ood.organization_id=mp.organization_id) ) order by ood.organization_code Source inventory organization for replenishment. Required when Source Type is Inventory or Subinventory. For Source Type = Subinventory the value must equal this row's Organization (same-org self-sourcing only). Must be blank when Source Type is blank or Supplier. 19 SOURCE_SUBINVENTORY LOV custom varchar2 Y select msec.secondary_inventory_name value, msec.description from mtl_secondary_inventories msec, mtl_parameters mp where mp.organization_code=:$column$.source_organization and msec.organization_id=mp.organization_id and msec.quantity_tracked=1 order by msec.secondary_inventory_name Source subinventory for replenishment. Optional in all source-type cases. When entered, must belong to the Source Organization and be quantity-tracked. Must be blank when Source Type is blank or Supplier. 20 PREPROCESSING_LEAD_TIME Number number Pre-processing lead time in days. Must be greater than or equal to 0. 21 PROCESSING_LEAD_TIME Number number Processing lead time in days. Must be greater than or equal to 0. 22 POSTPROCESSING_LEAD_TIME Number number Post-processing lead time in days. Must be greater than or equal to 0. 23 ITEM_SUB_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfc.descriptive_flex_context_name value, fdfc.description from fnd_descr_flex_contexts_vl fdfc where fdfc.descriptive_flexfield_name='MTL_ITEM_SUB_INVENTORIES' and fdfc.application_id=401 and fdfc.enabled_flag='Y' order by fdfc.descriptive_flex_context_name DFF context for the MTL_ITEM_SUB_INVENTORIES descriptive flexfield. Drives which DFF segment columns are required and validated. 24 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 25 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 26 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 27 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 28 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 29 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 30 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 31 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 32 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 33 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 34 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 35 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 36 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 37 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 38 ITEM_SUB_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_ITEM_SUB_INVENTORIES', p_context_name=>:$column$.item_sub_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.item_sub_attribute1, p_attribute2=>:$column$.item_sub_attribute2, p_attribute3=>:$column$.item_sub_attribute3, p_attribute4=>:$column$.item_sub_attribute4, p_attribute5=>:$column$.item_sub_attribute5, p_attribute6=>:$column$.item_sub_attribute6, p_attribute7=>:$column$.item_sub_attribute7, p_attribute8=>:$column$.item_sub_attribute8, p_attribute9=>:$column$.item_sub_attribute9, p_attribute10=>:$column$.item_sub_attribute10, p_attribute11=>:$column$.item_sub_attribute11, p_attribute12=>:$column$.item_sub_attribute12, p_attribute13=>:$column$.item_sub_attribute13, p_attribute14=>:$column$.item_sub_attribute14, p_attribute15=>:$column$.item_sub_attribute15 ) ) lov 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_ITEM_SUB_INVENTORIES' 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' 39 LOCATOR LOV custom varchar2 Y select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_item_locations_kfv milk, mtl_parameters mp where mp.organization_code=:$column$.organization_code and milk.organization_id=mp.organization_id and milk.subinventory_code=:$column$.subinventory order by milk.concatenated_segments Stock locator to assign the item to within the chosen Subinventory. Optional — when blank, only the item-subinventory header is processed; when populated, an item-subinventory-locator tie is also processed. Restricted to locators that exist in the chosen Organization+Subinventory (use the INV Stock Locator Upload to create new locators). Read-only on existing ties — to change the locator, delete the tie and create a new one. Y 40 LOCATOR_DESCRIPTION Char varchar2 select milk.description from mtl_item_locations_kfv milk, mtl_parameters mp where mp.organization_code=:$column$.organization_code and milk.organization_id=mp.organization_id and milk.subinventory_code=:$column$.subinventory and milk.concatenated_segments=:$column$.locator Locator description (read-only display). Y 41 PAR_LEVEL Number number PAR (Periodic Automatic Replenishment) Level for the locator tie. Only applicable when the parent Subinventory has PAR Level planning enabled; if the Subinventory is not PAR-enabled the uploaded value is silently ignored on create, and any stored value is cleared on update. Only mutable field on an existing locator tie. 42 DELETE_OPTION LOV custom varchar2 Y select value, description from ( select 'Subinventory' value, 'Delete the item-subinventory assignment (cascades to locator assignments)' description from dual union all select 'Locator' value, 'Delete the locator assignment' description from dual where :$column$.locator is not null ) order by value What to delete on this row. Choose Subinventory to delete the item-subinventory assignment (also cascades to all locator assignments for that item-subinventory). Choose Locator to delete just the locator assignment for this row (only offered when Locator is populated). Leave blank to create or update. 43 ONHAND_QUANTITY Number number On-hand quantity of the item in the subinventory in the primary unit of measure. Display only. Y 44 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 5 p_organization_id in Number ORGANIZATION_CODE U 6 p_inventory_item_id in Number ITEM U 7 p_subinventory in Char SUBINVENTORY U 8 p_min_max_planning in Char MIN_MAX_PLANNING U 9 p_min_minmax_quantity in Number MIN_MINMAX_QUANTITY U 10 p_max_minmax_quantity in Number MAX_MINMAX_QUANTITY U 11 p_fixed_lot_multiple in Number FIXED_LOT_MULTIPLE U 12 p_minimum_order_quantity in Number MINIMUM_ORDER_QUANTITY U 13 p_maximum_order_quantity in Number MAXIMUM_ORDER_QUANTITY U 14 p_source_type in Number SOURCE_TYPE U 15 p_source_organization_id in Number SOURCE_ORGANIZATION U 16 p_source_subinventory in Char SOURCE_SUBINVENTORY U 17 p_preprocessing_lead_time in Number PREPROCESSING_LEAD_TIME U 18 p_processing_lead_time in Number PROCESSING_LEAD_TIME U 19 p_postprocessing_lead_time in Number POSTPROCESSING_LEAD_TIME U 20 p_item_sub_attribute_category in Char ITEM_SUB_ATTRIBUTE_CATEGORY U 21 p_item_sub_attribute1 in Char ITEM_SUB_ATTRIBUTE1 U 22 p_item_sub_attribute2 in Char ITEM_SUB_ATTRIBUTE2 U 23 p_item_sub_attribute3 in Char ITEM_SUB_ATTRIBUTE3 U 24 p_item_sub_attribute4 in Char ITEM_SUB_ATTRIBUTE4 U 25 p_item_sub_attribute5 in Char ITEM_SUB_ATTRIBUTE5 U 26 p_item_sub_attribute6 in Char ITEM_SUB_ATTRIBUTE6 U 27 p_item_sub_attribute7 in Char ITEM_SUB_ATTRIBUTE7 U 28 p_item_sub_attribute8 in Char ITEM_SUB_ATTRIBUTE8 U 29 p_item_sub_attribute9 in Char ITEM_SUB_ATTRIBUTE9 U 30 p_item_sub_attribute10 in Char ITEM_SUB_ATTRIBUTE10 U 31 p_item_sub_attribute11 in Char ITEM_SUB_ATTRIBUTE11 U 32 p_item_sub_attribute12 in Char ITEM_SUB_ATTRIBUTE12 U 33 p_item_sub_attribute13 in Char ITEM_SUB_ATTRIBUTE13 U 34 p_item_sub_attribute14 in Char ITEM_SUB_ATTRIBUTE14 U 35 p_item_sub_attribute15 in Char ITEM_SUB_ATTRIBUTE15 U 36 p_inventory_location_id in Number LOCATOR U 37 p_par_level in Number PAR_LEVEL U 38 p_delete_option in Char DELETE_OPTION P 4 p_upload_mode in Char Error SQL Order By upload_row, organization_code, item, subinventory, locator Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, msiv.primary_uom_code uom, misi.secondary_inventory subinventory, msec.description subinventory_description, decode(misi.inventory_planning_code,2,xxen_util.meaning('Y','YES_NO',0)) min_max_planning, misi.min_minmax_quantity, misi.max_minmax_quantity, misi.fixed_lot_multiple, misi.minimum_order_quantity, misi.maximum_order_quantity, xxen_util.meaning(to_char(misi.source_type),'MTL_SOURCE_TYPES',700) source_type, mp_src.organization_code source_organization, misi.source_subinventory, misi.preprocessing_lead_time, misi.processing_lead_time, misi.postprocessing_lead_time, xxen_util.display_flexfield_context(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category) item_sub_attribute_category, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE1',misi.rowid,misi.attribute1) item_sub_attribute1, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE2',misi.rowid,misi.attribute2) item_sub_attribute2, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE3',misi.rowid,misi.attribute3) item_sub_attribute3, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE4',misi.rowid,misi.attribute4) item_sub_attribute4, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE5',misi.rowid,misi.attribute5) item_sub_attribute5, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE6',misi.rowid,misi.attribute6) item_sub_attribute6, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE7',misi.rowid,misi.attribute7) item_sub_attribute7, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE8',misi.rowid,misi.attribute8) item_sub_attribute8, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE9',misi.rowid,misi.attribute9) item_sub_attribute9, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE10',misi.rowid,misi.attribute10) item_sub_attribute10, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE11',misi.rowid,misi.attribute11) item_sub_attribute11, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE12',misi.rowid,misi.attribute12) item_sub_attribute12, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE13',misi.rowid,misi.attribute13) item_sub_attribute13, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE14',misi.rowid,misi.attribute14) item_sub_attribute14, xxen_util.display_flexfield_value(401,'MTL_ITEM_SUB_INVENTORIES',misi.attribute_category,'ATTRIBUTE15',misi.rowid,misi.attribute15) item_sub_attribute15, milk.concatenated_segments locator, milk.description locator_description, msl.maximum_quantity par_level, xu.delete_option, (select sum(moqd.primary_transaction_quantity) from mtl_onhand_quantities_detail moqd where misi.organization_id=moqd.organization_id and misi.inventory_item_id=moqd.inventory_item_id and misi.secondary_inventory=moqd.subinventory_code) onhand_quantity, xu.upload_row from ( select x.*, (select msiv2.inventory_item_id from mtl_system_items_vl msiv2, mtl_parameters mp2 where mp2.organization_code=x.organization_code and msiv2.organization_id=mp2.organization_id and msiv2.concatenated_segments=x.item) inventory_item_id, (select milk2.inventory_location_id from mtl_item_locations_kfv milk2, mtl_parameters mp2b where mp2b.organization_code=x.organization_code and milk2.organization_id=mp2b.organization_id and milk2.subinventory_code=x.subinventory and milk2.concatenated_segments=x.locator) inventory_location_id from xxen_inv_item_subinvent_7370_u x ) xu, mtl_item_sub_inventories misi, mtl_parameters mp, mtl_system_items_vl msiv, mtl_secondary_inventories msec, mtl_parameters mp_src, mtl_secondary_locators msl, mtl_item_locations_kfv milk where xu.status_code_=xxen_upload.status_success and mp.organization_code=xu.organization_code and msiv.inventory_item_id=xu.inventory_item_id and msiv.organization_id=mp.organization_id and msec.organization_id=mp.organization_id and msec.secondary_inventory_name=xu.subinventory and misi.organization_id(+)=mp.organization_id and misi.inventory_item_id(+)=xu.inventory_item_id and misi.secondary_inventory(+)=xu.subinventory and mp_src.organization_id(+)=misi.source_organization_id and msl.inventory_item_id(+)=misi.inventory_item_id and msl.organization_id(+)=misi.organization_id and msl.subinventory_code(+)=misi.secondary_inventory and msl.secondary_locator(+)=xu.inventory_location_id and milk.organization_id(+)=msl.organization_id and milk.subinventory_code(+)=msl.subinventory_code and milk.inventory_location_id(+)=msl.secondary_locator