ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EA3DBEFB604958FDE0530100007F2192 BOM Upload Assembly Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.description = nvl(:$column$.assembly_description,msiv.description) and mp.organization_code = :$column$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' order by msiv.concatenated_segments US EC5D45FC4EF5453CE0530100007F4A23 BOM Upload Assembly Desc Y select msiv.inventory_item_id id, msiv.description value, msiv.description || ' (' || msiv.concatenated_segments || ')' description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = nvl(:$column$.assembly_item,msiv.concatenated_segments) and mp.organization_code = :$column$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' order by msiv.description, msiv.concatenated_segments US 1655126A23BE97B8E0630100007FB4A8 BOM Upload Component Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.description = nvl(:$column$.component_description,msiv.description) order by msiv.concatenated_segments US 1655126A23C097B8E0630100007FB4A8 BOM Upload Component Desc Y select msiv.inventory_item_id id, msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.concatenated_segments = nvl(:$column$.component_item,msiv.concatenated_segments) order by msiv.description, msiv.concatenated_segments US EA3E0771733DE1A8E0530100007F201F BOM Upload Organization Code Y select mp2.organization_id id, mp2.organization_code value, ood.organization_name description from mtl_parameters mp, mtl_parameters mp2, org_organization_definitions ood, org_access_view oav where mp.organization_code = :$flex$.organization_code and mp.master_organization_id = mp2.master_organization_id and mp2.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and mp2.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate and (nvl(:$flex$.restrict_organization,'N') = 'N' or mp2.organization_code = :$flex$.organization_code ) order by mp2.organization_code US 1655126A23C297B8E0630100007FB4A8 BOM Upload Substitute Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.concatenated_segments != :$column$.component_item order by msiv.concatenated_segments US 1655126A23C397B8E0630100007FB4A8 BOM Upload Substitute Desc Y select msiv.inventory_item_id id, msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.concatenated_segments != :$column$.component_item order by msiv.description, msiv.concatenated_segments US E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 0B22DF18E239D64AE0630100007FBD85 INV Organization Code (including master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US All active inventory organization codes, restricted to the current user's org access view E97E834107173408E0530100007F830A with bom_tree as ( select /*+ materialize */ distinct bbom.bill_sequence_id from bom_bill_of_materials bbom ,bom_inventory_components bic where bbom.common_bill_sequence_id = bic.bill_sequence_id (+) and bbom.assembly_type = 1 and -- BOM nvl(bbom.effectivity_control,1) < 3 and nvl(bic.eco_for_production,2) = 2 and -- &lp_effective_display_clause1 &lp_effective_display_clause2 -- nvl(bbom.alternate_bom_designator,'?') = nvl(:p_alternate_bom,'?') and -- exclude common boms for the moment bbom.bill_sequence_id = bbom.common_bill_sequence_id and bbom.common_organization_id is null and bbom.common_assembly_item_id is null connect by nocycle prior decode(:p_explode_bom,'Y',bic.component_item_id,null) = bbom.assembly_item_id and prior decode(:p_explode_bom,'Y',bbom.organization_id,null) = bbom.organization_id and prior decode(:p_explode_bom,'Y',nvl(bbom.alternate_bom_designator,'?'),null) = nvl(bbom.alternate_bom_designator,'?') start with bbom.bill_sequence_id in (select /*+ materialize */ bbom.bill_sequence_id from mtl_parameters mp, mtl_system_items_vl msiv, bom_bill_of_materials bbom where mp.organization_id = msiv.organization_id and msiv.organization_id = bbom.organization_id and msiv.inventory_item_id = bbom.assembly_item_id and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and -- exclude product family bbom.assembly_type = 1 and -- BOM nvl(bbom.effectivity_control,1) < 3 and nvl(bbom.alternate_bom_designator,'?') = nvl(:p_alternate_bom,'?') and -- exclude common boms for the moment bbom.bill_sequence_id = bbom.common_bill_sequence_id and bbom.common_organization_id is null and bbom.common_assembly_item_id is null and mp.organization_code = :p_organization_code and 1=1 ) ), bom as ( select mp.organization_code, msiv1.concatenated_segments assembly_item, msiv1.description assembly_description, bbom.specific_assembly_comment bill_comment, xxen_util.meaning(decode(bbom.implementation_date,null,2,1),'SYS_YES_NO',700) bill_implemented_flag, bbom.implementation_date bill_implementation_date, bbom.effectivity_control effectivity_control_code, xxen_util.meaning(bbom.effectivity_control,'MTL_EFFECTIVITY_CONTROL',700) effectivity_control, bbom.alternate_bom_designator alternate_bom, xxen_util.meaning(nvl2(bbom.common_assembly_item_id,1,2),'SYS_YES_NO',700) common_bill_flag, xxen_util.display_flexfield_context(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category) bill_attribute_category, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE1',bbom.rowid) bom_bill_attribute1, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE2',bbom.rowid) bom_bill_attribute2, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE3',bbom.rowid) bom_bill_attribute3, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE4',bbom.rowid) bom_bill_attribute4, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE5',bbom.rowid) bom_bill_attribute5, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE6',bbom.rowid) bom_bill_attribute6, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE7',bbom.rowid) bom_bill_attribute7, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE8',bbom.rowid) bom_bill_attribute8, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE9',bbom.rowid) bom_bill_attribute9, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE10',bbom.rowid) bom_bill_attribute10, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE11',bbom.rowid) bom_bill_attribute11, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE12',bbom.rowid) bom_bill_attribute12, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE13',bbom.rowid) bom_bill_attribute13, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE14',bbom.rowid) bom_bill_attribute14, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE15',bbom.rowid) bom_bill_attribute15, -- msiv2.concatenated_segments component_item, msiv2.description component_description, bic.item_num item_seq, bic.operation_seq_num operation_seq, bic.component_quantity, round(decode(bic.component_quantity,0,0,1/bic.component_quantity),37) inverse_quantity, bic.effectivity_date date_effective_from, bic.disable_date date_effective_to, bic.from_end_item_unit_number end_item_unit_number_from, bic.to_end_item_unit_number end_item_unit_number_to, nvl(bic.basis_type,1) basis_type, xxen_util.meaning(nvl(bic.basis_type,1),'BOM_BASIS_TYPE',700) basis, bic.planning_factor planning_percent, bic.component_yield_factor yield, xxen_util.meaning(bic.enforce_int_requirements,'BOM_ENFORCE_INT_REQUIREMENTS',700) enforce_integer_quantity, xxen_util.meaning(bic.include_in_cost_rollup,'SYS_YES_NO',700) include_in_cost_rollup, xxen_util.meaning(bic.wip_supply_type,'WIP_SUPPLY',700) supply_type, bic.supply_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id = bic.supply_locator_id) supply_locator, xxen_util.meaning(decode(bic.implementation_date,null,2,1),'SYS_YES_NO',700) component_implemented_flag, bic.implementation_date component_implementation_date, xxen_util.display_flexfield_context(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category) component_attribute_category, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE1',bic.rowid) bom_comp_attribute1, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE2',bic.rowid) bom_comp_attribute2, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE3',bic.rowid) bom_comp_attribute3, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE4',bic.rowid) bom_comp_attribute4, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE5',bic.rowid) bom_comp_attribute5, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE6',bic.rowid) bom_comp_attribute6, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE7',bic.rowid) bom_comp_attribute7, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE8',bic.rowid) bom_comp_attribute8, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE9',bic.rowid) bom_comp_attribute9, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE10',bic.rowid) bom_comp_attribute10, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE11',bic.rowid) bom_comp_attribute11, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE12',bic.rowid) bom_comp_attribute12, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE13',bic.rowid) bom_comp_attribute13, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE14',bic.rowid) bom_comp_attribute14, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE15',bic.rowid) bom_comp_attribute15, -- bbom.bill_sequence_id, bbom.organization_id, bbom.assembly_item_id, bic.component_sequence_id, bic.component_item_id from bom_bill_of_materials bbom ,bom_inventory_components bic ,(select msiv.* from mtl_system_items_vl msiv where msiv.organization_id = :p_organization_id) msiv1 ,(select msiv.* from mtl_system_items_vl msiv where msiv.organization_id = :p_organization_id) msiv2 ,(select mp.* from mtl_parameters mp where mp.organization_id = :p_organization_id) mp where bbom.common_bill_sequence_id = bic.bill_sequence_id (+) and bbom.organization_id = mp.organization_id and bbom.assembly_item_id = msiv1.inventory_item_id and bbom.organization_id = msiv1.organization_id and bic.component_item_id = msiv2.inventory_item_id (+) and bbom.organization_id = nvl(msiv2.organization_id,bbom.organization_id) and -- bbom.bill_sequence_id in (select bom_tree.bill_sequence_id from bom_tree) and -- &lp_effective_display_clause1 &lp_effective_display_clause2 -- nvl(bic.eco_for_production,2) = 2 ), bom_subst as ( --from bom_substitute_components_v select bic2.component_sequence_id, bsc.substitute_component_id, msiv.concatenated_segments substitute_item, msiv.description substitute_description, bsc.substitute_item_quantity substitute_quantity, round(decode(bsc.substitute_item_quantity,0,0,1/bsc.substitute_item_quantity),37) substitute_inverse_quantity, xxen_util.meaning(bsc.enforce_int_requirements,'BOM_ENFORCE_INT_REQUIREMENTS',700) subst_integer_requirements, xxen_util.display_flexfield_context(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category) substitute_attribute_category, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE1',bsc.rowid) bom_sub_attribute1, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE2',bsc.rowid) bom_sub_attribute2, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE3',bsc.rowid) bom_sub_attribute3, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE4',bsc.rowid) bom_sub_attribute4, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE5',bsc.rowid) bom_sub_attribute5, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE6',bsc.rowid) bom_sub_attribute6, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE7',bsc.rowid) bom_sub_attribute7, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE8',bsc.rowid) bom_sub_attribute8, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE9',bsc.rowid) bom_sub_attribute9, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE10',bsc.rowid) bom_sub_attribute10, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE11',bsc.rowid) bom_sub_attribute11, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE12',bsc.rowid) bom_sub_attribute12, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE13',bsc.rowid) bom_sub_attribute13, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE14',bsc.rowid) bom_sub_attribute14, xxen_util.display_flexfield_value(702,'BOM_SUBSTITUTE_COMPONENTS',bsc.attribute_category,'ATTRIBUTE15',bsc.rowid) bom_sub_attribute15 from bom_substitute_components bsc, bom_bill_of_materials bbom, bom_inventory_components bic1, bom_inventory_components bic2, /* current component record */ mtl_system_items_vl msiv /* component being referenced */ where bsc.component_sequence_id = bic1.component_sequence_id and bic1.bill_sequence_id = bbom.bill_sequence_id and bsc.substitute_component_id = msiv.inventory_item_id and bbom.organization_id = msiv.organization_id and nvl(bsc.acd_type, 1) <> 3 and bic2.bill_sequence_id = bic1.bill_sequence_id and decode(bic2.implementation_date, null, bic2.old_component_sequence_id, bic2.component_sequence_id) = decode(bic1.implementation_date, null, bic1.old_component_sequence_id, bic1.component_sequence_id) and bic1.effectivity_date = (select max(bic3.effectivity_date) from bom_substitute_components bsc3, bom_inventory_components bic3 where bic3.component_sequence_id = bsc3.component_sequence_id and decode(bic3.implementation_date, null, bic3.old_component_sequence_id, bic3.component_sequence_id) = decode(bic1.implementation_date, null, bic1.old_component_sequence_id, bic1.component_sequence_id) and bic3.bill_sequence_id = bic1.bill_sequence_id and bsc3.substitute_component_id = bsc.substitute_component_id and bic3.effectivity_date <= bic2.effectivity_date ) ), processed_boms as (select /*+ ordered use_nl(bbom) push_pred(bom_subst) */ distinct xm.organization_code, xm.assembly_item, (select msit.description from mtl_system_items_tl msit where msit.organization_id = bbom.organization_id and msit.inventory_item_id = bbom.assembly_item_id and msit.language = userenv('lang')) assembly_description, bbom.specific_assembly_comment bill_comment, xxen_util.meaning(decode(bbom.implementation_date,null,2,1),'SYS_YES_NO',700) bill_implemented_flag, bbom.implementation_date bill_implementation_date, bbom.effectivity_control effectivity_control_code, xxen_util.meaning(bbom.effectivity_control,'MTL_EFFECTIVITY_CONTROL',700) effectivity_control, bbom.alternate_bom_designator alternate_bom, xxen_util.meaning(nvl2(bbom.common_assembly_item_id,1,2),'SYS_YES_NO',700) common_bill_flag, xxen_util.display_flexfield_context(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category) bill_attribute_category, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE1',bbom.rowid) bom_bill_attribute1, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE2',bbom.rowid) bom_bill_attribute2, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE3',bbom.rowid) bom_bill_attribute3, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE4',bbom.rowid) bom_bill_attribute4, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE5',bbom.rowid) bom_bill_attribute5, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE6',bbom.rowid) bom_bill_attribute6, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE7',bbom.rowid) bom_bill_attribute7, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE8',bbom.rowid) bom_bill_attribute8, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE9',bbom.rowid) bom_bill_attribute9, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE10',bbom.rowid) bom_bill_attribute10, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE11',bbom.rowid) bom_bill_attribute11, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE12',bbom.rowid) bom_bill_attribute12, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE13',bbom.rowid) bom_bill_attribute13, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE14',bbom.rowid) bom_bill_attribute14, xxen_util.display_flexfield_value(702,'BOM_BILL_OF_MATERIALS',bbom.attribute_category,'ATTRIBUTE15',bbom.rowid) bom_bill_attribute15, -- msik.concatenated_segments component_item, (select msit.description from mtl_system_items_tl msit where msit.organization_id = bbom.organization_id and msit.inventory_item_id = bic.component_item_id and msit.language = userenv('lang'))component_description, bic.item_num item_seq, bic.operation_seq_num operation_seq, bic.component_quantity, round(decode(bic.component_quantity,0,0,1/bic.component_quantity),37) inverse_quantity, bic.effectivity_date date_effective_from, bic.disable_date date_effective_to, bic.from_end_item_unit_number end_item_unit_number_from, bic.to_end_item_unit_number end_item_unit_number_to, nvl(bic.basis_type,1) basis_type, xxen_util.meaning(nvl(bic.basis_type,1),'BOM_BASIS_TYPE',700) basis, bic.planning_factor planning_percent, bic.component_yield_factor yield, xxen_util.meaning(bic.enforce_int_requirements,'BOM_ENFORCE_INT_REQUIREMENTS',700) enforce_integer_quantity, xxen_util.meaning(bic.include_in_cost_rollup,'SYS_YES_NO',700) include_in_cost_rollup, xxen_util.meaning(bic.wip_supply_type,'WIP_SUPPLY',700) supply_type, bic.supply_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id = bic.supply_locator_id) supply_locator, xxen_util.meaning(decode(bic.implementation_date,null,2,1),'SYS_YES_NO',700) component_implemented_flag, bic.implementation_date component_implementation_date, xxen_util.display_flexfield_context(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category) component_attribute_category, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE1',bic.rowid) bom_comp_attribute1, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE2',bic.rowid) bom_comp_attribute2, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE3',bic.rowid) bom_comp_attribute3, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE4',bic.rowid) bom_comp_attribute4, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE5',bic.rowid) bom_comp_attribute5, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE6',bic.rowid) bom_comp_attribute6, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE7',bic.rowid) bom_comp_attribute7, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE8',bic.rowid) bom_comp_attribute8, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE9',bic.rowid) bom_comp_attribute9, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE10',bic.rowid) bom_comp_attribute10, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE11',bic.rowid) bom_comp_attribute11, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE12',bic.rowid) bom_comp_attribute12, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE13',bic.rowid) bom_comp_attribute13, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE14',bic.rowid) bom_comp_attribute14, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bic.attribute_category,'ATTRIBUTE15',bic.rowid) bom_comp_attribute15, -- bom_subst.substitute_item, bom_subst.substitute_description, bom_subst.substitute_quantity, bom_subst.substitute_inverse_quantity, bom_subst.subst_integer_requirements, bom_subst.substitute_attribute_category, bom_subst.bom_sub_attribute1, bom_subst.bom_sub_attribute2, bom_subst.bom_sub_attribute3, bom_subst.bom_sub_attribute4, bom_subst.bom_sub_attribute5, bom_subst.bom_sub_attribute6, bom_subst.bom_sub_attribute7, bom_subst.bom_sub_attribute8, bom_subst.bom_sub_attribute9, bom_subst.bom_sub_attribute10, bom_subst.bom_sub_attribute11, bom_subst.bom_sub_attribute12, bom_subst.bom_sub_attribute13, bom_subst.bom_sub_attribute14, bom_subst.bom_sub_attribute15, -- bbom.bill_sequence_id, bbom.organization_id, bbom.assembly_item_id, bic.component_sequence_id, bic.component_item_id, bom_subst.substitute_component_id from (select /*+ materialize */ distinct xm.organization_code, xm.assembly_item, xm.alternate_bom, (select mp.organization_id from mtl_parameters mp where mp.organization_code=xm.organization_code) inv_org_id, (select msik.inventory_item_id from mtl_parameters mp,mtl_system_items_kfv msik where mp.organization_code=xm.organization_code and msik.organization_id = mp.organization_id and msik.concatenated_segments = xm.assembly_item) bom_item_id from xxen_bom_bill_of_materi_1523_u xm ) xm, bom_bill_of_materials bbom, bom_inventory_components bic, mtl_system_items_kfv msik, bom_subst where xm.inv_org_id = bbom.organization_id and xm.bom_item_id = bbom.assembly_item_id and nvl(xm.alternate_bom,' ') = nvl(bbom.alternate_bom_designator,' ') and -- bbom.common_bill_sequence_id = bic.bill_sequence_id and -- &lp_effective_display_clause1 &lp_effective_display_clause2 -- nvl(bic.eco_for_production,2) = 2 and bbom.organization_id = msik.organization_id and bic.component_item_id = msik.inventory_item_id and -- bic.component_sequence_id = bom_subst.component_sequence_id (+) ) -- -- Main Query Starts Here select /*+ push_pred(bom_subst) */ --process-- null action_, null status_, null message_, null request_id_, null modified_columns_, :p_upload_mode upload_mode, :p_enable_attrs_update enable_attrs_update, -- bom.organization_code, bom.assembly_item, bom.assembly_description, bom.bill_comment, bom.alternate_bom, bom.bill_implementation_date bill_implementation_date, bom.bill_implemented_flag, bom.common_bill_flag, bom.effectivity_control, bom.effectivity_control_code, bom.bill_attribute_category, bom.bom_bill_attribute1, bom.bom_bill_attribute2, bom.bom_bill_attribute3, bom.bom_bill_attribute4, bom.bom_bill_attribute5, bom.bom_bill_attribute6, bom.bom_bill_attribute7, bom.bom_bill_attribute8, bom.bom_bill_attribute9, bom.bom_bill_attribute10, bom.bom_bill_attribute11, bom.bom_bill_attribute12, bom.bom_bill_attribute13, bom.bom_bill_attribute14, bom.bom_bill_attribute15, -- bom.item_seq, bom.operation_seq operation_seq_old, bom.operation_seq, bom.component_item, bom.component_description, bom.component_quantity, bom.inverse_quantity, bom.date_effective_from date_effective_from_old, bom.date_effective_from date_effective_from, bom.date_effective_to date_effective_to, bom.end_item_unit_number_from end_item_unit_number_from_old, bom.end_item_unit_number_from, bom.end_item_unit_number_to, bom.basis_type, bom.basis, bom.planning_percent, bom.yield, bom.enforce_integer_quantity, bom.include_in_cost_rollup, bom.supply_type, bom.supply_subinventory, bom.supply_locator, bom.component_implemented_flag, bom.component_implementation_date component_implementation_date, bom.component_attribute_category, bom.bom_comp_attribute1, bom.bom_comp_attribute2, bom.bom_comp_attribute3, bom.bom_comp_attribute4, bom.bom_comp_attribute5, bom.bom_comp_attribute6, bom.bom_comp_attribute7, bom.bom_comp_attribute8, bom.bom_comp_attribute9, bom.bom_comp_attribute10, bom.bom_comp_attribute11, bom.bom_comp_attribute12, bom.bom_comp_attribute13, bom.bom_comp_attribute14, bom.bom_comp_attribute15, -- bom_subst.substitute_item substitute_item_old, bom_subst.substitute_item, bom_subst.substitute_description, bom_subst.substitute_quantity, bom_subst.substitute_inverse_quantity, bom_subst.subst_integer_requirements, bom_subst.substitute_attribute_category, bom_subst.bom_sub_attribute1, bom_subst.bom_sub_attribute2, bom_subst.bom_sub_attribute3, bom_subst.bom_sub_attribute4, bom_subst.bom_sub_attribute5, bom_subst.bom_sub_attribute6, bom_subst.bom_sub_attribute7, bom_subst.bom_sub_attribute8, bom_subst.bom_sub_attribute9, bom_subst.bom_sub_attribute10, bom_subst.bom_sub_attribute11, bom_subst.bom_sub_attribute12, bom_subst.bom_sub_attribute13, bom_subst.bom_sub_attribute14, bom_subst.bom_sub_attribute15, -- bom.bill_sequence_id, bom.organization_id, bom.assembly_item_id, bom.component_sequence_id, bom.component_item_id, bom_subst.substitute_component_id, to_char(null) row_id from bom, bom_subst where :p_display_option = :p_display_option and nvl(:p_restrict_org,'?') = nvl(:p_restrict_org,'?') and bom.component_sequence_id = bom_subst.component_sequence_id (+) Y U A xxen_bom_upload.upload_bom_record xxen_bom_upload.do_bom_import F BOM Bill of Materials Upload Importation de nomenclatures Description : Ce téléchargement peut être utilisé pour créer et/ou mettre à jour des nomenclatures standard existantes, notamment - l'en-tête de la nomenclature - les composants de la nomenclature - les substituts de composants de nomenclature. Cette fonctionnalité permet de créer et de mettre à jour des nomenclatures alternatives. La fonctionnalité ne permet pas la création et la mise à jour des nomenclatures communes. US BOM Bill of Materials Upload Report: BOM Bill of Materials Upload Description: This upload can be used to create and/or update existing standard BOMs, including - BOM Header - BOM Components - BOM Component Substitutes The functionality supports the creation and update of Alternate Bills. The functionality does not support the creation and update of Common Bills. Enginatics R12 only Upload &lp_effective_display_clause1 &lp_effective_display_clause2 1=1 :p_alternate_bom :p_display_option :p_enable_attrs_update :p_explode_bom :p_organization_code :p_organization_id :p_restrict_org :p_upload_mode 1 -100 :p_display_option_code Number select lookup_code from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' and meaning = :$flex$.Display US Display Option 2 -80 :p_organization_id Number select mp.organization_id from mtl_parameters mp where mp.organization_code = :$flex$.organization_code US Organization ID 3 -70 :p_enable_attrs_update LOV Oracle BOM_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning N US Enable Attributes Update 4 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 5 20 :p_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') Y US Organization Code 6 25 :p_restrict_org LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Restrict Organization 7 30 1=1 msiv.concatenated_segments=:p_assembly LOV custom Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where mp.organization_code = :$flex$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' and msiv.organization_id=mp.organization_id and exists (select null from bom_bill_of_materials bbom where bbom.assembly_type = 1 and -- BOM nvl(bbom.effectivity_control,1) <= 3 and bbom.bill_sequence_id = bbom.common_bill_sequence_id and -- exclude common boms for the moment bbom.alternate_bom_designator is null and -- exclude alternate designators for now bbom.organization_id = msiv.organization_id and bbom.assembly_item_id = msiv.inventory_item_id ) order by mp.organization_code, msiv.concatenated_segments US Assembly 8 40 :p_alternate_bom LOV custom Y select badvv.alternate_designator_code id, badvv.alternate_designator_code value, badvv.alternate_designator_code description from bom_alt_designators_val_v badvv where badvv.organization_id = -1 or badvv.organization_id = (select mp.organization_id from mtl_parameters mp where mp.organization_code = :$flex$.organization_code) order by value US Alternate BOM 9 50 :p_explode_bom LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Include Sub-Assemblies 10 60 :p_implemented_only LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Implemented Only 11 &lp_effective_display_clause1 -- displayed components and effectivity control -- implemented ( (nvl(:p_implemented_only,'Y') = 'Y' and bbom.implementation_date is not null and bic.implementation_date is not null) or (nvl(:p_implemented_only,'Y') = 'N') ) and -- effectivity ( ( bbom.effectivity_control = 1 and ( (nvl(:p_display_option_code,3) = 1) or --All -- Value Set BOM_SRS_INQUIRY_DISPLAY_TYPE Lookup BOM_INQUIRY_DISPLAY_TYPE View App 700 (nvl(:p_display_option_code,3) = 2 and nvl(:p_effective_date,sysdate) >= bic.effectivity_date and nvl(:p_effective_date,sysdate) < nvl(bic.disable_date, nvl(:p_effective_date,sysdate)+1)) or -- Current (nvl(:p_display_option_code,3) = 3 and nvl(:p_effective_date,sysdate) < nvl(bic.disable_date,nvl(:p_effective_date,sysdate)+1)) --Future and Current ) ) or ( bbom.effectivity_control <> 1 and ( (nvl(:p_display_option_code,3) = 1) or -- All (nvl(:p_display_option_code,3) <> 1 and bic.disable_date is null) -- Current, Future and Current ) ) ) and US Implemented Only 12 &lp_effective_display_clause2 ( ( bbom.effectivity_control = 1 and ( ( nvl(:p_implemented_only,'Y') = 'N' and ( nvl(:p_display_option_code,3) = 1 or --All ( nvl(:p_display_option_code,3) = 2 and -- Current bic.effectivity_date = (select max(bic2.effectivity_date) from bom_inventory_components bic2 where bic2.bill_sequence_id = bbom.bill_sequence_id and bic2.component_item_id = bic.component_item_id and ( decode(bic2.implementation_date, null, bic2.old_component_sequence_id, bic2.component_sequence_id) = decode(bic.implementation_date, null, bic.old_component_sequence_id, bic.component_sequence_id) or bic2.operation_seq_num = bic.operation_seq_num ) and bic2.effectivity_date <= nvl(:p_effective_date,sysdate) and not exists (select null from bom_inventory_components bic3 where bic3.bill_sequence_id = bbom.bill_sequence_id and bic3.old_component_sequence_id = bic.component_sequence_id and bic3.acd_type in (2,3) and bic3.disable_date < nvl(:p_effective_date,sysdate) ) ) ) or ( nvl(:p_display_option_code,3) = 3 and -- Future and Current bic.effectivity_date = (select max(bic2.effectivity_date) from bom_inventory_components bic2 where bic2.bill_sequence_id = bbom.bill_sequence_id and bic2.component_item_id = bic.component_item_id and ( decode(bic2.implementation_date, null, bic2.old_component_sequence_id, bic2.component_sequence_id) = decode(bic.implementation_date, null, bic.old_component_sequence_id, bic.component_sequence_id) or bic2.operation_seq_num = bic.operation_seq_num ) and bic2.effectivity_date <= nvl(:p_effective_date,sysdate) and not exists (select null from bom_inventory_components bic3 where bic3.bill_sequence_id = bbom.bill_sequence_id and bic3.old_component_sequence_id = bic.component_sequence_id and bic3.acd_type in (2,3) and bic3.disable_date < nvl(:p_effective_date,sysdate) ) ) or bic.effectivity_date > nvl(:p_effective_date,sysdate) ) ) ) or ( nvl(:p_implemented_only,'Y') = 'Y' and bic.implementation_date is not null ) ) ) or ( bbom.effectivity_control <> 1 and ( (nvl(:p_implemented_only,'Y') = 'N') or (nvl(:p_implemented_only,'Y') = 'Y' and bic.implementation_date is not null) ) ) ) and US Implemented Only 13 70 :p_display_option LOV custom select meaning value, null description from mfg_lookups where lookup_type='BOM_INQUIRY_DISPLAY_TYPE' order by value,description xxen_util.meaning(3,'BOM_INQUIRY_DISPLAY_TYPE',700) Y US Display 14 80 :p_effective_date DateTime SYSDATE Y US Effective Date :$flex$.Display Display Display Option :$flex$.organization_code Organization Code Alternate BOM :$flex$.organization_code Organization Code Assembly :$flex$.organization_code Organization Code Organization ID 524BE18C2D3FCBD01A81BFCF40070D10 BOM Upload Template Y SYSADMIN 5 ALTERNATE_BOM -7.0008 ALTERNATE_BOM_DESIGNATOR 3 ASSEMBLY_DESCRIPTION Y 2 ASSEMBLY_ITEM 28 ASSEMBLY_ITEM_ID -14.0015 AWS Windchill Part Number BASIS BASIS_TYPE BILL_ATTRIBUTE_CATEGORY 4 BILL_COMMENT BILL_IMPLEMENTATION_DATE BILL_IMPLEMENTED_FLAG 26 BILL_SEQUENCE_ID BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE9 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE9 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE9 COMMON_BILL_FLAG COMPONENT_ATTRIBUTE_CATEGORY 9 COMPONENT_DESCRIPTION Y COMPONENT_IMPLEMENTATION_DATE COMPONENT_IMPLEMENTED_FLAG 8 COMPONENT_ITEM 30 COMPONENT_ITEM_ID 10 COMPONENT_QUANTITY 29 COMPONENT_SEQUENCE_ID -14.0022 Charge Description Master 12 DATE_EFFECTIVE_FROM 13 DATE_EFFECTIVE_TO EFFECTIVITY_CONTROL_CODE EFFECTIVITY_CONTROL_FLAG 16 ENFORCE_INTEGER_QUANTITY -17.0018 FROM_END_ITEM_UNIT_NUMBER -14.0016 Graphical Link for Web Reqs 17 INCLUDE_IN_COST_ROLLUP INDENT_LEVEL 11 INVERSE_QUANTITY 6 ITEM_SEQ -14.0017 Invoice UOM -14.0023 Item Model LINE_TYPE -14.0018 Late Demands Penalty -14.0019 Material Over-Capacity Penalty 7 OPERATION_SEQ 1 ORGANIZATION_CODE 27 ORGANIZATION_ID 14 PLANNING_PERCENT ROOT_ASSEMBLY_ITEM ROOT_BILL_SEQUENCE_ID ROOT_ORGANIZATION_CODE SUBSTITUTE_ATTRIBUTE_CATEGORY 31 SUBSTITUTE_COMPONENT_ID 22 SUBSTITUTE_DESCRIPTION 24 SUBSTITUTE_INVERSE_QUANTITY 21 SUBSTITUTE_ITEM 23 SUBSTITUTE_QUANTITY 25 SUBST_INTEGER_REQUIREMENTS 20 SUPPLY_LOCATOR 19 SUPPLY_SUBINVENTORY 18 SUPPLY_TYPE -17.0019 TO_END_ITEM_UNIT_NUMBER -14.0024 Tax Denomination -14.002 Type of RMA Supported at RAD -14.0021 UPN 15 YIELD S Site 4510BC870BE1CD44F69BF758CDE03209 BOM Upload Template with DFF Attributes Y BOM Upload Template including columns for the BOM, Component, and Substitute Descriptive Flexfield Attributes SYSADMIN 5 ALTERNATE_BOM -7.0008 ALTERNATE_BOM_DESIGNATOR 3 ASSEMBLY_DESCRIPTION Y 2 ASSEMBLY_ITEM 76 ASSEMBLY_ITEM_ID -14.0015 AWS Windchill Part Number BASIS BASIS_TYPE 6 BILL_ATTRIBUTE_CATEGORY 4 BILL_COMMENT BILL_IMPLEMENTATION_DATE BILL_IMPLEMENTED_FLAG 74 BILL_SEQUENCE_ID 7 BOM_BILL_ATTRIBUTE1 16 BOM_BILL_ATTRIBUTE10 17 BOM_BILL_ATTRIBUTE11 18 BOM_BILL_ATTRIBUTE12 19 BOM_BILL_ATTRIBUTE13 20 BOM_BILL_ATTRIBUTE14 21 BOM_BILL_ATTRIBUTE15 8 BOM_BILL_ATTRIBUTE2 9 BOM_BILL_ATTRIBUTE3 10 BOM_BILL_ATTRIBUTE4 11 BOM_BILL_ATTRIBUTE5 12 BOM_BILL_ATTRIBUTE6 13 BOM_BILL_ATTRIBUTE7 14 BOM_BILL_ATTRIBUTE8 15 BOM_BILL_ATTRIBUTE9 38 BOM_COMP_ATTRIBUTE1 47 BOM_COMP_ATTRIBUTE10 48 BOM_COMP_ATTRIBUTE11 49 BOM_COMP_ATTRIBUTE12 50 BOM_COMP_ATTRIBUTE13 51 BOM_COMP_ATTRIBUTE14 52 BOM_COMP_ATTRIBUTE15 39 BOM_COMP_ATTRIBUTE2 40 BOM_COMP_ATTRIBUTE3 41 BOM_COMP_ATTRIBUTE4 42 BOM_COMP_ATTRIBUTE5 43 BOM_COMP_ATTRIBUTE6 44 BOM_COMP_ATTRIBUTE7 45 BOM_COMP_ATTRIBUTE8 46 BOM_COMP_ATTRIBUTE9 59 BOM_SUB_ATTRIBUTE1 68 BOM_SUB_ATTRIBUTE10 69 BOM_SUB_ATTRIBUTE11 70 BOM_SUB_ATTRIBUTE12 71 BOM_SUB_ATTRIBUTE13 72 BOM_SUB_ATTRIBUTE14 73 BOM_SUB_ATTRIBUTE15 60 BOM_SUB_ATTRIBUTE2 61 BOM_SUB_ATTRIBUTE3 62 BOM_SUB_ATTRIBUTE4 63 BOM_SUB_ATTRIBUTE5 64 BOM_SUB_ATTRIBUTE6 65 BOM_SUB_ATTRIBUTE7 66 BOM_SUB_ATTRIBUTE8 67 BOM_SUB_ATTRIBUTE9 COMMON_BILL_FLAG 37 COMPONENT_ATTRIBUTE_CATEGORY 25 COMPONENT_DESCRIPTION Y COMPONENT_IMPLEMENTATION_DATE COMPONENT_IMPLEMENTED_FLAG 24 COMPONENT_ITEM 78 COMPONENT_ITEM_ID 26 COMPONENT_QUANTITY 77 COMPONENT_SEQUENCE_ID -14.0022 Charge Description Master 28 DATE_EFFECTIVE_FROM 29 DATE_EFFECTIVE_TO EFFECTIVITY_CONTROL_CODE EFFECTIVITY_CONTROL_FLAG 32 ENFORCE_INTEGER_QUANTITY -17.0018 FROM_END_ITEM_UNIT_NUMBER -14.0016 Graphical Link for Web Reqs 33 INCLUDE_IN_COST_ROLLUP INDENT_LEVEL 27 INVERSE_QUANTITY 22 ITEM_SEQ -14.0017 Invoice UOM -14.0023 Item Model LINE_TYPE -14.0018 Late Demands Penalty -14.0019 Material Over-Capacity Penalty 23 OPERATION_SEQ 1 ORGANIZATION_CODE 75 ORGANIZATION_ID 30 PLANNING_PERCENT ROOT_ASSEMBLY_ITEM ROOT_BILL_SEQUENCE_ID ROOT_ORGANIZATION_CODE 58 SUBSTITUTE_ATTRIBUTE_CATEGORY 79 SUBSTITUTE_COMPONENT_ID 54 SUBSTITUTE_DESCRIPTION 56 SUBSTITUTE_INVERSE_QUANTITY 53 SUBSTITUTE_ITEM 55 SUBSTITUTE_QUANTITY 57 SUBST_INTEGER_REQUIREMENTS 36 SUPPLY_LOCATOR 35 SUPPLY_SUBINVENTORY 34 SUPPLY_TYPE -17.0019 TO_END_ITEM_UNIT_NUMBER -14.0024 Tax Denomination -14.002 Type of RMA Supported at RAD -14.0021 UPN 31 YIELD S Site SYSADMIN 4510BC870BE1CD44F69BF758CDE03209 524BE18C2D3FCBD01A81BFCF40070D10 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 fnd_global.conc_request_id Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 UPLOAD_MODE Char varchar2 :$flex$.upload_mode Y 7 ENABLE_ATTRS_UPDATE Char varchar2 :$flex$.Enable_Attributes_Update Y 8 ORGANIZATION_CODE LOV varchar2 BOM Upload Organization Code EA3E0771733DE1A8E0530100007F201F Y select mp2.organization_id id, mp2.organization_code value, ood.organization_name description from mtl_parameters mp, mtl_parameters mp2, org_organization_definitions ood, org_access_view oav where mp.organization_code = :$flex$.organization_code and mp.master_organization_id = mp2.master_organization_id and mp2.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and mp2.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate and (nvl(:$flex$.restrict_organization,'N') = 'N' or mp2.organization_code = :$flex$.organization_code ) order by mp2.organization_code Y Y 9 ASSEMBLY_ITEM LOV varchar2 BOM Upload Assembly EA3DBEFB604958FDE0530100007F2192 Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.description = nvl(:$column$.assembly_description,msiv.description) and mp.organization_code = :$column$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' order by msiv.concatenated_segments Y Y Y 10 ASSEMBLY_DESCRIPTION LOV varchar2 BOM Upload Assembly Desc EC5D45FC4EF5453CE0530100007F4A23 Y select msiv.inventory_item_id id, msiv.description value, msiv.description || ' (' || msiv.concatenated_segments || ')' description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = nvl(:$column$.assembly_item,msiv.concatenated_segments) and mp.organization_code = :$column$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' order by msiv.description, msiv.concatenated_segments select msiv.description value from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = nvl(:$column$.assembly_item,msiv.concatenated_segments) and mp.organization_code = :$column$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' Y 11 BILL_COMMENT Char varchar2 12 ALTERNATE_BOM LOV custom varchar2 Y select badvv.alternate_designator_code id, badvv.alternate_designator_code value, badvv.alternate_designator_code description from bom_alt_designators_val_v badvv where badvv.organization_id = -1 or badvv.organization_id = (select mp.organization_id from mtl_parameters mp where mp.organization_code = :$column$.organization_code) order by value Y 13 BILL_IMPLEMENTATION_DATE DateTime date 14 BILL_IMPLEMENTED_FLAG Char varchar2 15 COMMON_BILL_FLAG Char varchar2 16 EFFECTIVITY_CONTROL LOV custom varchar2 Y select msiv.inventory_item_id id, xxen_util.meaning(msiv.effectivity_control,'MTL_EFFECTIVITY_CONTROL',700) value, xxen_util.meaning(msiv.effectivity_control,'MTL_EFFECTIVITY_CONTROL',700) description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and (msiv.description = :$column$.assembly_description or msiv.concatenated_segments = :$column$.assembly_item ) and mp.organization_code= :$column$.organization_code Y Y 17 EFFECTIVITY_CONTROL_CODE Number number 18 BILL_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 19 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 20 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 21 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 22 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 23 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 24 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 25 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 26 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 27 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 28 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 29 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 30 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 31 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 32 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 33 BOM_BILL_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 => 702, p_descriptive_flexfield_name => 'BOM_BILL_OF_MATERIALS', p_context_name => :$column$.bill_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.bom_bill_attribute1, p_attribute2 => :$column$.bom_bill_attribute2, p_attribute3 => :$column$.bom_bill_attribute3, p_attribute4 => :$column$.bom_bill_attribute4, p_attribute5 => :$column$.bom_bill_attribute5, p_attribute6 => :$column$.bom_bill_attribute6, p_attribute7 => :$column$.bom_bill_attribute7, p_attribute8 => :$column$.bom_bill_attribute8, p_attribute9 => :$column$.bom_bill_attribute9, p_attribute10 => :$column$.bom_bill_attribute10, p_attribute11 => :$column$.bom_bill_attribute11, p_attribute12 => :$column$.bom_bill_attribute12, p_attribute13 => :$column$.bom_bill_attribute13, p_attribute14 => :$column$.bom_bill_attribute14, p_attribute15 => :$column$.bom_bill_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_BILL_OF_MATERIALS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 34 ITEM_SEQ Number number 35 OPERATION_SEQ_OLD Number number Y Y 36 OPERATION_SEQ LOV custom number Y select x.* from ( select bos.operation_seq_num id, bos.operation_seq_num value, bos.operation_seq_num description from bom_operation_sequences bos, bom_operational_routings bor, bom_bill_of_materials bbom, mtl_system_items_vl msiv, mtl_parameters mp where bos.routing_sequence_id = bor.common_routing_sequence_id and bor.organization_id = mp.organization_id and bor.organization_id = bbom.organization_id (+) and bor.assembly_item_id = bbom.assembly_item_id (+) and bor.assembly_item_id = msiv.inventory_item_id and bor.organization_id = msiv.organization_id and (msiv.description = :$column$.assembly_description or msiv.concatenated_segments = :$column$.assembly_item ) and mp.organization_code=:$column$.organization_code and nvl(bos.disable_date, trunc(sysdate)+1) >= sysdate and nvl(bos.operation_type,1) = 1 and bor.alternate_routing_designator is null and bbom.assembly_type (+) = 1 and -- BOM nvl(bbom.effectivity_control,1) <= 3 and nvl(bbom.bill_sequence_id,-1) = nvl(bbom.common_bill_sequence_id,-1) and -- exclude common boms for the moment bbom.alternate_bom_designator is null -- exclude alternate designator operating sequences union select 1, 1, 1 from dual where (:$column$.assembly_description = :$column$.assembly_description or :$column$.assembly_item = :$column$.assembly_item ) ) x 1 37 COMPONENT_ITEM LOV varchar2 BOM Upload Component 1655126A23BE97B8E0630100007FB4A8 Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.description = nvl(:$column$.component_description,msiv.description) order by msiv.concatenated_segments Y Y 38 COMPONENT_DESCRIPTION LOV varchar2 BOM Upload Component Desc 1655126A23C097B8E0630100007FB4A8 Y select msiv.inventory_item_id id, msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.concatenated_segments = nvl(:$column$.component_item,msiv.concatenated_segments) order by msiv.description, msiv.concatenated_segments select msiv.description value from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = nvl(:$column$.component_item,msiv.concatenated_segments) and mp.organization_code = :$column$.organization_code and msiv.bom_enabled_flag = 'Y' and msiv.bom_item_type != 5 and msiv.eng_item_flag = 'N' Y 39 COMPONENT_QUANTITY LOV custom number select round(decode(:$column$.inverse_quantity,0,0,1/:$column$.inverse_quantity),37) value, null description from dual where :$column$.inverse_quantity is not null select round(decode(:$column$.inverse_quantity,0,0,1/:$column$.inverse_quantity),37) from dual where :$column$.inverse_quantity is not null 40 INVERSE_QUANTITY LOV custom number select round(decode(:$column$.component_quantity,0,0,1/:$column$.component_quantity),37) value, null description from dual where :$column$.component_quantity is not null select round(decode(:$column$.component_quantity,0,0,1/:$column$.component_quantity),37) from dual where :$column$.component_quantity is not null 41 DATE_EFFECTIVE_FROM_OLD DateTime date Y Y 42 DATE_EFFECTIVE_FROM DateTime date Y 43 DATE_EFFECTIVE_TO DateTime date 44 END_ITEM_UNIT_NUMBER_FROM_OLD Char varchar2 Y Y 45 END_ITEM_UNIT_NUMBER_FROM LOV custom varchar2 Y select pun.unit_number id, pun.unit_number value, pun.unit_number description from pjm_unit_numbers pun, mtl_item_flexfields mif where mif.inventory_item_id = pun.end_item_id and mif.organization_id = pun.master_organization_id and mif.organization_id = (select mp.master_organization_id from mtl_parameters mp where mp.organization_code = :$column$.organization_code ) order by pun.unit_number Y 46 END_ITEM_UNIT_NUMBER_TO LOV custom varchar2 Y select pun.unit_number id, pun.unit_number value, pun.unit_number description from pjm_unit_numbers pun, mtl_item_flexfields mif where mif.inventory_item_id = pun.end_item_id and mif.organization_id = pun.master_organization_id and mif.organization_id = (select mp.master_organization_id from mtl_parameters mp where mp.organization_code = :$flex$.organization_code ) order by pun.unit_number Y 47 BASIS_TYPE Number number 48 BASIS Char varchar2 49 PLANNING_PERCENT Number number 100 50 YIELD Number number 1 51 ENFORCE_INTEGER_QUANTITY LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, ml.description description from mfg_lookups ml where ml.lookup_type = 'BOM_ENFORCE_INT_REQUIREMENTS' 52 INCLUDE_IN_COST_ROLLUP LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, ml.description description from mfg_lookups ml where ml.lookup_type = 'SYS_YES_NO' select ml.lookup_code id, ml.meaning value from mfg_lookups ml where ml.lookup_type = 'SYS_YES_NO' select xxen_util.meaning(msiv.default_include_in_rollup_flag,'YES_NO',0) from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.component_item and mp.organization_code = :$column$.organization_code 53 SUPPLY_TYPE LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' and ml.lookup_code != 7 order by ml.meaning select ml.lookup_code id, ml.meaning value from mfg_lookups ml where ml.lookup_type = 'WIP_SUPPLY' select xxen_util.meaning(msiv.wip_supply_type,'WIP_SUPPLY',700) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_id = msiv.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.component_item 54 SUPPLY_SUBINVENTORY LOV custom varchar2 Y select msi.secondary_inventory_name value, msi.description from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_id = msi.organization_id and mp.organization_code = :$column$.organization_code order by value 55 SUPPLY_LOCATOR LOV custom varchar2 Y select milk.concatenated_segments value, milk.description from mtl_parameters mp, mtl_item_locations_kfv milk where mp.organization_id = milk.organization_id and mp.organization_code = :$column$.organization_code and milk.subinventory_code = :$column$.supply_subinventory order by value 56 COMPONENT_IMPLEMENTED_FLAG Char varchar2 57 COMPONENT_IMPLEMENTATION_DATE DateTime date 58 COMPONENT_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 59 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 60 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 61 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 62 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 63 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 64 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 65 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 66 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 67 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 68 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 69 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 70 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 71 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 72 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 73 BOM_COMP_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 => 702, p_descriptive_flexfield_name => 'BOM_INVENTORY_COMPONENTS', p_context_name => :$column$.component_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.bom_comp_attribute1, p_attribute2 => :$column$.bom_comp_attribute2, p_attribute3 => :$column$.bom_comp_attribute3, p_attribute4 => :$column$.bom_comp_attribute4, p_attribute5 => :$column$.bom_comp_attribute5, p_attribute6 => :$column$.bom_comp_attribute6, p_attribute7 => :$column$.bom_comp_attribute7, p_attribute8 => :$column$.bom_comp_attribute8, p_attribute9 => :$column$.bom_comp_attribute9, p_attribute10 => :$column$.bom_comp_attribute10, p_attribute11 => :$column$.bom_comp_attribute11, p_attribute12 => :$column$.bom_comp_attribute12, p_attribute13 => :$column$.bom_comp_attribute13, p_attribute14 => :$column$.bom_comp_attribute14, p_attribute15 => :$column$.bom_comp_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 74 SUBSTITUTE_ITEM_OLD Char varchar2 Y Y 75 SUBSTITUTE_ITEM LOV varchar2 BOM Upload Substitute 1655126A23C297B8E0630100007FB4A8 Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.concatenated_segments != :$column$.component_item order by msiv.concatenated_segments 76 SUBSTITUTE_DESCRIPTION LOV varchar2 BOM Upload Substitute Desc 1655126A23C397B8E0630100007FB4A8 Y select msiv.inventory_item_id id, msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv, mtl_parameters mp, (select msiv.organization_id, msiv.inventory_item_id, msiv.concatenated_segments assembly_item, msiv.bom_item_type, msiv.eam_item_type, msiv.base_item_id, msiv.replenish_to_order_flag, msiv.pick_components_flag, msiv.effectivity_control, bom_eamutil.enabled unit_effective_flag, case when bom_eamutil.enabled = 'Y' and bom_eamutil.serial_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'Y' then 'Y' else 'N' end is_serial_effective from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.assembly_item and mp.organization_code = :$column$.organization_code ) bom where msiv.organization_id = mp.organization_id and msiv.eng_item_flag = 'N' and (msiv.bom_enabled_flag = 'Y' or (msiv.bom_enabled_flag = 'N' and exists (select null from bom_bill_of_materials bbom, bom_components_b bcb where bbom.bill_sequence_id = bcb.bill_sequence_id and bbom.organization_id = bom.organization_id and bbom.assembly_item_id = bom.inventory_item_id and bcb.component_item_id = msiv.inventory_item_id and bcb.pk2_value = msiv.organization_id ) ) ) and (mp.process_enabled_flag='N' or msiv.bom_item_type not in (1,2)) and ((bom.bom_item_type = 1 and msiv.bom_item_type != 3) or (bom.bom_item_type = 2 and msiv.bom_item_type != 3) or (bom.bom_item_type = 4 and msiv.bom_item_type = 4) or (bom.bom_item_type = 4 and bom.eam_item_type is null and bom.base_item_id is not null and bom.replenish_to_order_flag = 'Y' and msiv.bom_item_type in (1,2) and msiv.replenish_to_order_flag = 'Y') ) and (bom.bom_item_type = 3 or bom.pick_components_flag = 'Y' or msiv.pick_components_flag = 'N' ) and (bom.bom_item_type = 3 or nvl(msiv.bom_item_type,4) != 2 or (bom.bom_item_type = 2 and bom.pick_components_flag = 'Y' and msiv.pick_components_flag = 'Y') or (bom.bom_item_type = 2 and bom.replenish_to_order_flag = 'Y' and msiv.replenish_to_order_flag = 'Y') ) and (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'),2) = 1 or not(bom.bom_item_type = 4 and bom.pick_components_flag = 'Y' and msiv.bom_item_type = 4 and msiv.replenish_to_order_flag = 'Y') ) and ((bom.is_serial_effective = 'Y' and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) not in (1,2)) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control = 1 and msiv.effectivity_control = 1 and nvl(msiv.eam_item_type,0) !=2) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'Y' and bom.effectivity_control != 1 and msiv.bom_item_type = 4 and nvl(msiv.eam_item_type,0) !=1 and nvl(msiv.item_type,'999') not in ('AI', 'AOC', 'ATO', 'POC', 'PTO')) or (bom.is_serial_effective = 'N' and bom.unit_effective_flag = 'N' and msiv.effectivity_control = 1) ) and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments != :$column$.assembly_item and msiv.concatenated_segments != :$column$.component_item order by msiv.description, msiv.concatenated_segments select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.substitute_item 77 SUBSTITUTE_QUANTITY LOV custom number select round(decode(:$column$.substitute_inverse_quantity,0,0,1/:$column$.substitute_inverse_quantity),37) value, null description from dual where :$column$.substitute_inverse_quantity is not null select round(decode(:$column$.substitute_inverse_quantity,0,0,1/:$column$.substitute_inverse_quantity),37) from dual where :$column$.substitute_inverse_quantity is not null 78 SUBSTITUTE_INVERSE_QUANTITY LOV custom number select round(decode(:$column$.substitute_quantity,0,0,1/:$column$.substitute_quantity),37) value, null description from dual where :$column$.substitute_quantity is not null select round(decode(:$column$.substitute_quantity,0,0,1/:$column$.substitute_quantity),37) from dual where :$column$.substitute_quantity is not null 79 SUBST_INTEGER_REQUIREMENTS LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, ml.description description from mfg_lookups ml where ml.lookup_type = 'BOM_ENFORCE_INT_REQUIREMENTS' 80 SUBSTITUTE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 81 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 82 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 83 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 84 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 85 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 86 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 87 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 88 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 89 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 90 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 91 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 92 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 93 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 94 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 95 BOM_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 => 702, p_descriptive_flexfield_name => 'BOM_SUBSTITUTE_COMPONENTS', p_context_name => :$column$.substitute_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.bom_sub_attribute1, p_attribute2 => :$column$.bom_sub_attribute2, p_attribute3 => :$column$.bom_sub_attribute3, p_attribute4 => :$column$.bom_sub_attribute4, p_attribute5 => :$column$.bom_sub_attribute5, p_attribute6 => :$column$.bom_sub_attribute6, p_attribute7 => :$column$.bom_sub_attribute7, p_attribute8 => :$column$.bom_sub_attribute8, p_attribute9 => :$column$.bom_sub_attribute9, p_attribute10 => :$column$.bom_sub_attribute10, p_attribute11 => :$column$.bom_sub_attribute11, p_attribute12 => :$column$.bom_sub_attribute12, p_attribute13 => :$column$.bom_sub_attribute13, p_attribute14 => :$column$.bom_sub_attribute14, p_attribute15 => :$column$.bom_sub_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 702 and fdfv.descriptive_flexfield_name = 'BOM_SUBSTITUTE_COMPONENTS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 96 BILL_SEQUENCE_ID Number number Y 97 ORGANIZATION_ID Number number Y 98 ASSEMBLY_ITEM_ID Number number Y 99 COMPONENT_SEQUENCE_ID Number number Y 100 COMPONENT_ITEM_ID Number number Y 101 SUBSTITUTE_COMPONENT_ID Number number Y 102 ROW_ID Char varchar2 Y Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_row_id in/out Char ROW_ID U 6 p_organization_code in Char ORGANIZATION_CODE value U 7 p_assembly_item in Char ASSEMBLY_ITEM value U 9 p_alternate_bom_designator in Char ALTERNATE_BOM U 10 p_bill_comment in Char BILL_COMMENT U 11 p_effectivity_control in Char EFFECTIVITY_CONTROL value U 12 p_bom_attribute_category in Char Y BILL_ATTRIBUTE_CATEGORY U 13 p_bom_attribute1 in Char Y BOM_BILL_ATTRIBUTE1 U 14 p_bom_attribute2 in Char Y BOM_BILL_ATTRIBUTE2 U 15 p_bom_attribute3 in Char Y BOM_BILL_ATTRIBUTE3 U 16 p_bom_attribute4 in Char Y BOM_BILL_ATTRIBUTE4 U 17 p_bom_attribute5 in Char Y BOM_BILL_ATTRIBUTE5 U 18 p_bom_attribute6 in Char Y BOM_BILL_ATTRIBUTE6 U 19 p_bom_attribute7 in Char Y BOM_BILL_ATTRIBUTE7 U 20 p_bom_attribute8 in Char Y BOM_BILL_ATTRIBUTE8 U 21 p_bom_attribute9 in Char Y BOM_BILL_ATTRIBUTE9 U 22 p_bom_attribute10 in Char Y BOM_BILL_ATTRIBUTE10 U 23 p_bom_attribute11 in Char Y BOM_BILL_ATTRIBUTE11 U 24 p_bom_attribute12 in Char Y BOM_BILL_ATTRIBUTE12 U 25 p_bom_attribute13 in Char Y BOM_BILL_ATTRIBUTE13 U 26 p_bom_attribute14 in Char Y BOM_BILL_ATTRIBUTE14 U 27 p_bom_attribute15 in Char Y BOM_BILL_ATTRIBUTE15 U 28 p_item_seq in Number ITEM_SEQ U 29 p_operation_seq_old in Number OPERATION_SEQ_OLD U 30 p_operation_seq in Number OPERATION_SEQ value U 31 p_component_item in Char COMPONENT_ITEM value U 33 p_component_quantity in Number COMPONENT_QUANTITY U 34 p_inverse_quantity in Number INVERSE_QUANTITY U 35 p_date_effective_from_old in Date DATE_EFFECTIVE_FROM_OLD U 36 p_date_effective_from in Date DATE_EFFECTIVE_FROM U 37 p_date_effective_to in Date DATE_EFFECTIVE_TO U 38 p_planning_percent in Number PLANNING_PERCENT U 39 p_projected_yield in Number YIELD U 40 p_include_in_cost_rollup in Number INCLUDE_IN_COST_ROLLUP U 41 p_enforce_int_requirements in Char ENFORCE_INTEGER_QUANTITY value U 42 p_wip_supply_type in Number SUPPLY_TYPE U 43 p_supply_subinventory in Char SUPPLY_SUBINVENTORY U 44 p_supply_locator in Char SUPPLY_LOCATOR U 45 p_end_item_unit_num_from_old in Char END_ITEM_UNIT_NUMBER_FROM_OLD U 46 p_end_item_unit_number_from in Char END_ITEM_UNIT_NUMBER_FROM U 47 p_end_item_unit_number_to in Char END_ITEM_UNIT_NUMBER_TO U 48 p_comp_attribute_category in Char Y COMPONENT_ATTRIBUTE_CATEGORY U 49 p_comp_attribute1 in Char Y BOM_COMP_ATTRIBUTE1 U 50 p_comp_attribute2 in Char Y BOM_COMP_ATTRIBUTE2 U 51 p_comp_attribute3 in Char Y BOM_COMP_ATTRIBUTE3 U 52 p_comp_attribute4 in Char Y BOM_COMP_ATTRIBUTE4 U 53 p_comp_attribute5 in Char Y BOM_COMP_ATTRIBUTE5 U 54 p_comp_attribute6 in Char Y BOM_COMP_ATTRIBUTE6 U 55 p_comp_attribute7 in Char Y BOM_COMP_ATTRIBUTE7 U 56 p_comp_attribute8 in Char Y BOM_COMP_ATTRIBUTE8 U 57 p_comp_attribute9 in Char Y BOM_COMP_ATTRIBUTE9 U 58 p_comp_attribute10 in Char Y BOM_COMP_ATTRIBUTE10 U 59 p_comp_attribute11 in Char Y BOM_COMP_ATTRIBUTE11 U 60 p_comp_attribute12 in Char Y BOM_COMP_ATTRIBUTE12 U 61 p_comp_attribute13 in Char Y BOM_COMP_ATTRIBUTE13 U 62 p_comp_attribute14 in Char Y BOM_COMP_ATTRIBUTE14 U 63 p_comp_attribute15 in Char Y BOM_COMP_ATTRIBUTE15 U 64 p_substitute_item_old in Char SUBSTITUTE_ITEM_OLD U 65 p_substitute_item in Char SUBSTITUTE_ITEM value U 67 p_substitute_quantity in Number SUBSTITUTE_QUANTITY U 68 p_substitute_inverse_quantity in Number SUBSTITUTE_INVERSE_QUANTITY U 69 p_substitute_enforce_int_req in Char SUBST_INTEGER_REQUIREMENTS value U 70 p_sub_attribute_category in Char Y SUBSTITUTE_ATTRIBUTE_CATEGORY U 71 p_sub_attribute1 in Char Y BOM_SUB_ATTRIBUTE1 U 72 p_sub_attribute2 in Char Y BOM_SUB_ATTRIBUTE2 U 73 p_sub_attribute3 in Char Y BOM_SUB_ATTRIBUTE3 U 74 p_sub_attribute4 in Char Y BOM_SUB_ATTRIBUTE4 U 75 p_sub_attribute5 in Char Y BOM_SUB_ATTRIBUTE5 U 76 p_sub_attribute6 in Char Y BOM_SUB_ATTRIBUTE6 U 77 p_sub_attribute7 in Char Y BOM_SUB_ATTRIBUTE7 U 78 p_sub_attribute8 in Char Y BOM_SUB_ATTRIBUTE8 U 79 p_sub_attribute9 in Char Y BOM_SUB_ATTRIBUTE9 U 80 p_sub_attribute10 in Char Y BOM_SUB_ATTRIBUTE10 U 81 p_sub_attribute11 in Char Y BOM_SUB_ATTRIBUTE11 U 82 p_sub_attribute12 in Char Y BOM_SUB_ATTRIBUTE12 U 83 p_sub_attribute13 in Char Y BOM_SUB_ATTRIBUTE13 U 84 p_sub_attribute14 in Char Y BOM_SUB_ATTRIBUTE14 U 85 p_sub_attribute15 in Char Y BOM_SUB_ATTRIBUTE15 P 1 status_ out Char STATUS_CODE_ P 2 message_ out Char MESSAGE_ P 3 request_id_ out Number REQUEST_ID_ P 4 p_upload_mode in Char UPLOAD_MODE P 5 p_enable_attrs_update in Char Y ENABLE_ATTRS_UPDATE P 6 p_common_bom_org_id_list in Char Y Order By organization_code, assembly_item, operation_seq, item_seq, component_item, substitute_item Success SQL select decode(xu.pstatus,xxen_upload.status_success,xxen_upload.action_meaning(xxen_upload.action_update),xxen_upload.status_error,xu.action_,null) action_, xxen_upload.status_meaning(xu.pstatus) status_, nvl(xxen_bom_upload.get_message_(xu.request_id_,xu.row_id,xu.organization_code,xu.assembly_item),xu.message_) message_, xu.request_id_ request_id_, xu.modified_columns_, xu.upload_mode, xu.enable_attrs_update, -- decode(xu.pstatus,xxen_upload.status_error,xu.organization_code,bom.organization_code) organization_code, decode(xu.pstatus,xxen_upload.status_error,xu.assembly_item,bom.assembly_item) assembly_item, decode(xu.pstatus,xxen_upload.status_error,xu.assembly_description,bom.assembly_description) assembly_description, decode(xu.pstatus,xxen_upload.status_error,xu.bill_comment,bom.bill_comment) bill_comment, decode(xu.pstatus,xxen_upload.status_error,xu.alternate_bom,bom.alternate_bom) alternate_bom, decode(xu.pstatus,xxen_upload.status_error,xu.bill_implementation_date,bom.bill_implementation_date) bill_implementation_date, decode(xu.pstatus,xxen_upload.status_error,xu.bill_implemented_flag,bom.bill_implemented_flag) bill_implemented_flag, decode(xu.pstatus,xxen_upload.status_error,xu.common_bill_flag,bom.common_bill_flag) common_bill_flag, decode(xu.pstatus,xxen_upload.status_error,xu.effectivity_control,bom.effectivity_control) effectivity_control, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.effectivity_control_code),bom.effectivity_control_code) effectivity_control_code, decode(xu.pstatus,xxen_upload.status_error,xu.bill_attribute_category,bom.bill_attribute_category) bill_attribute_category, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute1,bom.bom_bill_attribute1) bom_bill_attribute1, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute2,bom.bom_bill_attribute2) bom_bill_attribute2, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute3,bom.bom_bill_attribute3) bom_bill_attribute3, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute4,bom.bom_bill_attribute4) bom_bill_attribute4, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute5,bom.bom_bill_attribute5) bom_bill_attribute5, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute6,bom.bom_bill_attribute6) bom_bill_attribute6, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute7,bom.bom_bill_attribute7) bom_bill_attribute7, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute8,bom.bom_bill_attribute8) bom_bill_attribute8, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute9,bom.bom_bill_attribute9) bom_bill_attribute9, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute10,bom.bom_bill_attribute10) bom_bill_attribute10, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute11,bom.bom_bill_attribute11) bom_bill_attribute11, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute12,bom.bom_bill_attribute12) bom_bill_attribute12, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute13,bom.bom_bill_attribute13) bom_bill_attribute13, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute14,bom.bom_bill_attribute14) bom_bill_attribute14, decode(xu.pstatus,xxen_upload.status_error,xu.bom_bill_attribute15,bom.bom_bill_attribute15) bom_bill_attribute15, -- decode(xu.pstatus,xxen_upload.status_error,to_number(xu.item_seq),bom.item_seq) item_seq, decode(xu.pstatus,xxen_upload.status_error,to_number(decode(xu.action_code_,xxen_upload.action_create,null,xu.operation_seq_old)),bom.operation_seq) operation_seq_old, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.operation_seq),bom.operation_seq) operation_seq, decode(xu.pstatus,xxen_upload.status_error,xu.component_item,bom.component_item) component_item, decode(xu.pstatus,xxen_upload.status_error,xu.component_description,bom.component_description) component_description, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.component_quantity),bom.component_quantity) component_quantity, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.inverse_quantity),bom.inverse_quantity) inverse_quantity, decode(xu.pstatus,xxen_upload.status_error,decode(xu.action_code_,xxen_upload.action_create,to_date(null),xu.date_effective_from_old),bom.date_effective_from) date_effective_from_old, decode(xu.pstatus,xxen_upload.status_error,xu.date_effective_from,bom.date_effective_from) date_effective_from, decode(xu.pstatus,xxen_upload.status_error,xu.date_effective_to,bom.date_effective_to) date_effective_to, decode(xu.pstatus,xxen_upload.status_error,decode(xu.action_code_,xxen_upload.action_create,null,xu.end_item_unit_number_from_old),bom.end_item_unit_number_from) end_item_unit_number_from_old, decode(xu.pstatus,xxen_upload.status_error,xu.end_item_unit_number_from,bom.end_item_unit_number_from) end_item_unit_number_from, decode(xu.pstatus,xxen_upload.status_error,xu.end_item_unit_number_to,bom.end_item_unit_number_to) end_item_unit_number_to, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.basis_type),bom.basis_type) basis_type, decode(xu.pstatus,xxen_upload.status_error,xu.basis,bom.basis) basis, decode(xu.pstatus,xxen_upload.status_error,xu.planning_percent,bom.planning_percent) planning_percent, decode(xu.pstatus,xxen_upload.status_error,xu.yield,bom.yield) yield, decode(xu.pstatus,xxen_upload.status_error,xu.enforce_integer_quantity,bom.enforce_integer_quantity) enforce_integer_quantity, decode(xu.pstatus,xxen_upload.status_error,xu.include_in_cost_rollup,bom.include_in_cost_rollup) include_in_cost_rollup, decode(xu.pstatus,xxen_upload.status_error,xu.supply_type,bom.supply_type) supply_type, decode(xu.pstatus,xxen_upload.status_error,xu.supply_subinventory,bom.supply_subinventory) supply_subinventory, decode(xu.pstatus,xxen_upload.status_error,xu.supply_locator,bom.supply_locator) supply_locator, decode(xu.pstatus,xxen_upload.status_error,xu.component_implemented_flag,bom.component_implemented_flag) component_implemented_flag, decode(xu.pstatus,xxen_upload.status_error,xu.component_implementation_date,bom.component_implementation_date) component_implementation_date, decode(xu.pstatus,xxen_upload.status_error,xu.component_attribute_category,bom.component_attribute_category) component_attribute_category, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute1,bom.bom_comp_attribute1) bom_comp_attribute1, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute2,bom.bom_comp_attribute2) bom_comp_attribute2, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute3,bom.bom_comp_attribute3) bom_comp_attribute3, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute4,bom.bom_comp_attribute4) bom_comp_attribute4, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute5,bom.bom_comp_attribute5) bom_comp_attribute5, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute6,bom.bom_comp_attribute6) bom_comp_attribute6, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute7,bom.bom_comp_attribute7) bom_comp_attribute7, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute8,bom.bom_comp_attribute8) bom_comp_attribute8, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute9,bom.bom_comp_attribute9) bom_comp_attribute9, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute10,bom.bom_comp_attribute10) bom_comp_attribute10, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute11,bom.bom_comp_attribute11) bom_comp_attribute11, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute12,bom.bom_comp_attribute12) bom_comp_attribute12, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute13,bom.bom_comp_attribute13) bom_comp_attribute13, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute14,bom.bom_comp_attribute14) bom_comp_attribute14, decode(xu.pstatus,xxen_upload.status_error,xu.bom_comp_attribute15,bom.bom_comp_attribute15) bom_comp_attribute15, -- decode(xu.pstatus,xxen_upload.status_error,xu.substitute_item_old,bom.substitute_item) substitute_item_old, decode(xu.pstatus,xxen_upload.status_error,xu.substitute_item,bom.substitute_item) substitute_item, decode(xu.pstatus,xxen_upload.status_error,xu.substitute_description,bom.substitute_description) substitute_description, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.substitute_quantity),bom.substitute_quantity) substitute_quantity, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.substitute_inverse_quantity),bom.substitute_inverse_quantity) substitute_inverse_quantity, decode(xu.pstatus,xxen_upload.status_error,xu.subst_integer_requirements,bom.subst_integer_requirements) subst_integer_requirements, decode(xu.pstatus,xxen_upload.status_error,xu.substitute_attribute_category,bom.substitute_attribute_category) substitute_attribute_category, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute1,bom.bom_sub_attribute1) bom_sub_attribute1, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute2,bom.bom_sub_attribute2) bom_sub_attribute2, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute3,bom.bom_sub_attribute3) bom_sub_attribute3, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute4,bom.bom_sub_attribute4) bom_sub_attribute4, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute5,bom.bom_sub_attribute5) bom_sub_attribute5, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute6,bom.bom_sub_attribute6) bom_sub_attribute6, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute7,bom.bom_sub_attribute7) bom_sub_attribute7, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute8,bom.bom_sub_attribute8) bom_sub_attribute8, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute9,bom.bom_sub_attribute9) bom_sub_attribute9, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute10,bom.bom_sub_attribute10) bom_sub_attribute10, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute11,bom.bom_sub_attribute11) bom_sub_attribute11, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute12,bom.bom_sub_attribute12) bom_sub_attribute12, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute13,bom.bom_sub_attribute13) bom_sub_attribute13, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute14,bom.bom_sub_attribute14) bom_sub_attribute14, decode(xu.pstatus,xxen_upload.status_error,xu.bom_sub_attribute15,bom.bom_sub_attribute15) bom_sub_attribute15, -- decode(xu.pstatus,xxen_upload.status_error,to_number(xu.bill_sequence_id),bom.bill_sequence_id) bill_sequence_id, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.organization_id),bom.organization_id) organization_id, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.assembly_item_id),bom.assembly_item_id) assembly_item_id, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.component_sequence_id),bom.component_sequence_id) component_sequence_id, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.component_item_id),bom.component_item_id) component_item_id, decode(xu.pstatus,xxen_upload.status_error,to_number(xu.substitute_component_id),bom.substitute_component_id) substitute_component_id, xu.row_id from (select nvl(xxen_bom_upload.get_status_(xu.request_id_,xu.row_id,xu.organization_code,xu.assembly_item),xu.status_code_) pstatus, xu.* from xxen_bom_bill_of_materi_1523_u xu) xu full join processed_boms bom on ( xu.organization_code = bom.organization_code and xu.assembly_item = bom.assembly_item and nvl(xu.alternate_bom,'?') = nvl(bom.alternate_bom,'?') and xu.component_item = bom.component_item and to_number(decode(xu.pstatus,xxen_upload.status_error,nvl(xu.operation_seq_old,nvl(xu.operation_seq,1)),nvl(xu.operation_seq,1))) = bom.operation_seq and nvl(decode(xu.pstatus,xxen_upload.status_error,nvl(xu.end_item_unit_number_from_old,xu.end_item_unit_number_from),xu.end_item_unit_number_from),'?') = nvl(bom.end_item_unit_number_from,'?') and nvl(decode(xu.pstatus,xxen_upload.status_error,nvl(xu.date_effective_from_old,xu.date_effective_from),xu.date_effective_from),to_date('01/01/4712','DD/MM/YYYY')) = nvl(bom.date_effective_from,to_date('01/01/4712','DD/MM/YYYY')) and nvl(decode(xu.pstatus,xxen_upload.status_error,nvl(xu.substitute_item_old,xu.substitute_item),xu.substitute_item),'?') = nvl(bom.substitute_item,'?') ) LOV query :$column$.organization_code ORGANIZATION_CODE ALTERNATE_BOM Default value :$column$.assembly_item ASSEMBLY_ITEM ASSEMBLY_DESCRIPTION LOV query :$column$.assembly_item ASSEMBLY_ITEM ASSEMBLY_DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE ASSEMBLY_DESCRIPTION LOV query :$column$.organization_code ORGANIZATION_CODE ASSEMBLY_DESCRIPTION LOV query :$column$.assembly_description ASSEMBLY_DESCRIPTION ASSEMBLY_ITEM LOV query :$column$.organization_code ORGANIZATION_CODE ASSEMBLY_ITEM LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE1 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE10 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE11 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE12 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE13 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE14 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE15 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE2 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE3 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE4 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE5 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE6 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE7 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE8 LOV query :$column$.bill_attribute_category BILL_ATTRIBUTE_CATEGORY BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute1 BOM_BILL_ATTRIBUTE1 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute10 BOM_BILL_ATTRIBUTE10 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute11 BOM_BILL_ATTRIBUTE11 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute12 BOM_BILL_ATTRIBUTE12 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute13 BOM_BILL_ATTRIBUTE13 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute14 BOM_BILL_ATTRIBUTE14 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute15 BOM_BILL_ATTRIBUTE15 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute2 BOM_BILL_ATTRIBUTE2 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute3 BOM_BILL_ATTRIBUTE3 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute4 BOM_BILL_ATTRIBUTE4 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute5 BOM_BILL_ATTRIBUTE5 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute6 BOM_BILL_ATTRIBUTE6 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute7 BOM_BILL_ATTRIBUTE7 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute8 BOM_BILL_ATTRIBUTE8 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_bill_attribute9 BOM_BILL_ATTRIBUTE9 BOM_BILL_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE1 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE1 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE10 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE10 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE11 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE11 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE12 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE12 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE13 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE13 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE14 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE14 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE15 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE15 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE2 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE2 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE3 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE3 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE4 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE4 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE5 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE5 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE6 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE6 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE7 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE7 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE8 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE8 LOV query :$column$.bom_comp_attribute1 BOM_COMP_ATTRIBUTE1 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute10 BOM_COMP_ATTRIBUTE10 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute11 BOM_COMP_ATTRIBUTE11 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute12 BOM_COMP_ATTRIBUTE12 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute13 BOM_COMP_ATTRIBUTE13 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute14 BOM_COMP_ATTRIBUTE14 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute15 BOM_COMP_ATTRIBUTE15 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute2 BOM_COMP_ATTRIBUTE2 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute3 BOM_COMP_ATTRIBUTE3 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute4 BOM_COMP_ATTRIBUTE4 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute5 BOM_COMP_ATTRIBUTE5 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute6 BOM_COMP_ATTRIBUTE6 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute7 BOM_COMP_ATTRIBUTE7 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute8 BOM_COMP_ATTRIBUTE8 BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_comp_attribute9 BOM_COMP_ATTRIBUTE9 BOM_COMP_ATTRIBUTE9 LOV query :$column$.component_attribute_category COMPONENT_ATTRIBUTE_CATEGORY BOM_COMP_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE1 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE1 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE10 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE10 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE11 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE11 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE12 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE12 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE13 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE13 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE14 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE14 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE15 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE15 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE2 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE2 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE3 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE3 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE4 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE4 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE5 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE5 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE6 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE6 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE7 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE7 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE8 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE8 LOV query :$column$.bom_sub_attribute1 BOM_SUB_ATTRIBUTE1 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute10 BOM_SUB_ATTRIBUTE10 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute11 BOM_SUB_ATTRIBUTE11 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute12 BOM_SUB_ATTRIBUTE12 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute13 BOM_SUB_ATTRIBUTE13 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute14 BOM_SUB_ATTRIBUTE14 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute15 BOM_SUB_ATTRIBUTE15 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute2 BOM_SUB_ATTRIBUTE2 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute3 BOM_SUB_ATTRIBUTE3 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute4 BOM_SUB_ATTRIBUTE4 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute5 BOM_SUB_ATTRIBUTE5 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute6 BOM_SUB_ATTRIBUTE6 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute7 BOM_SUB_ATTRIBUTE7 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute8 BOM_SUB_ATTRIBUTE8 BOM_SUB_ATTRIBUTE9 LOV query :$column$.bom_sub_attribute9 BOM_SUB_ATTRIBUTE9 BOM_SUB_ATTRIBUTE9 LOV query :$column$.substitute_attribute_category SUBSTITUTE_ATTRIBUTE_CATEGORY BOM_SUB_ATTRIBUTE9 LOV query :$column$.assembly_item ASSEMBLY_ITEM COMPONENT_DESCRIPTION Default value :$column$.component_item COMPONENT_ITEM COMPONENT_DESCRIPTION LOV query :$column$.component_item COMPONENT_ITEM COMPONENT_DESCRIPTION LOV query :$column$.organization_code ORGANIZATION_CODE COMPONENT_DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE COMPONENT_DESCRIPTION LOV query :$column$.assembly_item ASSEMBLY_ITEM COMPONENT_ITEM LOV query :$column$.component_description COMPONENT_DESCRIPTION COMPONENT_ITEM LOV query :$column$.organization_code ORGANIZATION_CODE COMPONENT_ITEM LOV query :$column$.inverse_quantity INVERSE_QUANTITY COMPONENT_QUANTITY Default value :$column$.inverse_quantity INVERSE_QUANTITY COMPONENT_QUANTITY LOV query :$column$.assembly_description ASSEMBLY_DESCRIPTION EFFECTIVITY_CONTROL LOV query :$column$.assembly_item ASSEMBLY_ITEM EFFECTIVITY_CONTROL LOV query :$column$.organization_code ORGANIZATION_CODE EFFECTIVITY_CONTROL Default value :$flex$.Enable_Attributes_Update Enable Attributes Update|:p_enable_attrs_update| ENABLE_ATTRS_UPDATE LOV query :$column$.organization_code ORGANIZATION_CODE END_ITEM_UNIT_NUMBER_FROM LOV query :$flex$.organization_code Organization Code|:p_organization_code| END_ITEM_UNIT_NUMBER_TO Default value :$column$.component_item COMPONENT_ITEM INCLUDE_IN_COST_ROLLUP Default value :$column$.organization_code ORGANIZATION_CODE INCLUDE_IN_COST_ROLLUP LOV query :$column$.component_quantity COMPONENT_QUANTITY INVERSE_QUANTITY Default value :$column$.component_quantity COMPONENT_QUANTITY INVERSE_QUANTITY LOV query :$column$.assembly_description ASSEMBLY_DESCRIPTION OPERATION_SEQ LOV query :$column$.assembly_item ASSEMBLY_ITEM OPERATION_SEQ LOV query :$column$.organization_code ORGANIZATION_CODE OPERATION_SEQ LOV query :$flex$.organization_code Organization Code|:p_organization_code| ORGANIZATION_CODE LOV query :$flex$.restrict_organization Restrict Organization|:p_restrict_org| ORGANIZATION_CODE LOV query :$column$.assembly_item ASSEMBLY_ITEM SUBSTITUTE_DESCRIPTION LOV query :$column$.component_item COMPONENT_ITEM SUBSTITUTE_DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE SUBSTITUTE_DESCRIPTION LOV query :$column$.organization_code ORGANIZATION_CODE SUBSTITUTE_DESCRIPTION Default value :$column$.substitute_item SUBSTITUTE_ITEM SUBSTITUTE_DESCRIPTION Default value :$column$.substitute_quantity SUBSTITUTE_QUANTITY SUBSTITUTE_INVERSE_QUANTITY LOV query :$column$.substitute_quantity SUBSTITUTE_QUANTITY SUBSTITUTE_INVERSE_QUANTITY LOV query :$column$.assembly_item ASSEMBLY_ITEM SUBSTITUTE_ITEM LOV query :$column$.component_item COMPONENT_ITEM SUBSTITUTE_ITEM LOV query :$column$.organization_code ORGANIZATION_CODE SUBSTITUTE_ITEM LOV query :$column$.substitute_inverse_quantity SUBSTITUTE_INVERSE_QUANTITY SUBSTITUTE_QUANTITY Default value :$column$.substitute_inverse_quantity SUBSTITUTE_INVERSE_QUANTITY SUBSTITUTE_QUANTITY LOV query :$column$.organization_code ORGANIZATION_CODE SUPPLY_LOCATOR LOV query :$column$.supply_subinventory SUPPLY_SUBINVENTORY SUPPLY_LOCATOR LOV query :$column$.organization_code ORGANIZATION_CODE SUPPLY_SUBINVENTORY Default value :$column$.component_item COMPONENT_ITEM SUPPLY_TYPE Default value :$column$.organization_code ORGANIZATION_CODE SUPPLY_TYPE Default value :$flex$.upload_mode Upload Mode|1=1| UPLOAD_MODE