DBA Data[Home] [Help]

APPS.ENI_DBI_PCO_LOAD_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 161: BOM_IMPLOSION_TEMP bit, BOM_BILL_OF_MATERIALS bbom

157: msi.organization_id = bit.organization_id) AS bom_item_type,
158: NULL as worker_id,
159: 0 as incr_status
160: FROM
161: BOM_IMPLOSION_TEMP bit, BOM_BILL_OF_MATERIALS bbom
162: WHERE
163: bit.parent_item_id = bbom.assembly_item_id
164: AND bit.organization_id = bbom.organization_id
165: AND bbom.bill_sequence_id = bbom.common_bill_sequence_id

Line 732: select 1 from bom_bill_of_materials bbom

728: -- Filtering out the phantom items.
729: b1.component_item_id = i.inventory_item_id and
730: b1.organization_id = i.organization_id and
731: not exists (
732: select 1 from bom_bill_of_materials bbom
733: where bbom.assembly_item_id = b1.component_item_id and
734: bbom.organization_id = b1.organization_id) and
735: (NOT(((1,'PTO') IN (select i3.bom_item_type,i3.item_type
736: from mtl_system_items_b i3

Line 773: select 1 from bom_bill_of_materials bbom

769: -- Filtering out the phantom items.
770: b1.component_item_id = i.inventory_item_id and
771: b1.organization_id = i.organization_id and
772: not exists (
773: select 1 from bom_bill_of_materials bbom
774: where bbom.assembly_item_id = b1.component_item_id and
775: bbom.organization_id = b1.organization_id) and
776: (NOT(((1,'PTO') IN (select i3.bom_item_type,i3.item_type
777: from mtl_system_items_b i3