APPS.ENI_DBI_PCO_LOAD_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 152: (select msi.pick_components_flag from mtl_system_items_b msi

148: )
149: (SELECT unique
150: bit.parent_item_id AS assembly_item_id,
151: bit.organization_id AS organization_id,
152: (select msi.pick_components_flag from mtl_system_items_b msi
153: where msi.inventory_item_id = bit.parent_item_id and
154: msi.organization_id = bit.organization_id) AS pick_components_flag,
155: (select msi.bom_item_type from mtl_system_items_b msi
156: where msi.inventory_item_id = bit.parent_item_id and

Line 155: (select msi.bom_item_type from mtl_system_items_b msi

151: bit.organization_id AS organization_id,
152: (select msi.pick_components_flag from mtl_system_items_b msi
153: where msi.inventory_item_id = bit.parent_item_id and
154: msi.organization_id = bit.organization_id) AS pick_components_flag,
155: (select msi.bom_item_type from mtl_system_items_b msi
156: where msi.inventory_item_id = bit.parent_item_id and
157: msi.organization_id = bit.organization_id) AS bom_item_type,
158: NULL as worker_id,
159: 0 as incr_status

Line 205: from bom_structures_b bbom,mtl_system_items_b msi -- Bug # 3394284

201: msi.pick_components_flag AS pto_flag,
202: msi.bom_item_type AS bom_type,
203: NULL worker_id,
204: 0 AS incr_status
205: from bom_structures_b bbom,mtl_system_items_b msi -- Bug # 3394284
206: where bill_sequence_id = common_bill_sequence_id and
207: bbom.alternate_bom_designator IS NULL and
208: bbom.organization_id = msi.organization_id and
209: bbom.assembly_item_id = msi.inventory_item_id and

Line 232: from bom_structures_b bbom,mtl_system_items_b msi

228: msi.pick_components_flag AS pto_flag,
229: msi.bom_item_type AS bom_type,
230: NULL worker_id,
231: 0 AS incr_status
232: from bom_structures_b bbom,mtl_system_items_b msi
233: where
234: bbom.alternate_bom_designator IS NULL and
235: bbom.organization_id = g_organization_id and
236: NVL(bbom.common_organization_id,bbom.organization_id) = msi.organization_id and

Line 544: -- the set of items in mtl_system_items_b

540: end_time DATE;
541: time_taken NUMBER(20,10);
542: s_id NUMBER(10);
543: p_error_occured NUMBER := 0;
544: -- the set of items in mtl_system_items_b
545: -- which have BOM_ENABLED_FLAG set to 'Y'.
546: begin
547:
548: IF(FND_INSTALLATION.GET_APP_INFO('ENI', l_status, l_industry, g_eni_schema))

Line 720: bom_explosion_temp b1,mtl_system_items_b i

716: trunc(NVL(b1.disable_date,to_date('1-1-2085','dd-mm-yyyy'))),
717: b1.plan_level,
718: -1
719: FROM
720: bom_explosion_temp b1,mtl_system_items_b i
721: WHERE
722: b1.component_sequence_id IS NOT NULL and
723: b1.bom_item_type <> 2 and
724: -- Filtering out the Option classes items which

Line 736: from mtl_system_items_b i3

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
737: where i3.inventory_item_id = b1.top_item_id and
738: i3.organization_id = b1.organization_id)) and
739: ((2,'POC') IN (select i2.bom_item_type,i2.item_type
740: from mtl_system_items_b i2

Line 740: from mtl_system_items_b i2

736: from mtl_system_items_b i3
737: where i3.inventory_item_id = b1.top_item_id and
738: i3.organization_id = b1.organization_id)) and
739: ((2,'POC') IN (select i2.bom_item_type,i2.item_type
740: from mtl_system_items_b i2
741: where i2.inventory_item_id = b1.assembly_item_id and
742: i2.organization_id = b1.organization_id))));
743: ELSE
744: INSERT /*+ APPEND */ INTO eni_dbi_part_count_incr_temp

Line 761: bom_explosion_temp b1,mtl_system_items_b i

757: trunc(b1.effectivity_date),
758: trunc(NVL(b1.disable_date,to_date('1-1-2085','dd-mm-yyyy'))),
759: b1.plan_level
760: FROM
761: bom_explosion_temp b1,mtl_system_items_b i
762: WHERE
763: b1.component_sequence_id IS NOT NULL and
764: b1.bom_item_type <> 2 and
765: -- Filtering out the Option classes items which

Line 777: from mtl_system_items_b i3

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
778: where i3.inventory_item_id = b1.top_item_id and
779: i3.organization_id = b1.organization_id)) and
780: ((2,'POC') IN (select i2.bom_item_type,i2.item_type
781: from mtl_system_items_b i2

Line 781: from mtl_system_items_b i2

777: from mtl_system_items_b i3
778: where i3.inventory_item_id = b1.top_item_id and
779: i3.organization_id = b1.organization_id)) and
780: ((2,'POC') IN (select i2.bom_item_type,i2.item_type
781: from mtl_system_items_b i2
782: where i2.inventory_item_id = b1.assembly_item_id and
783: i2.organization_id = b1.organization_id))));
784: END IF;
785: EXCEPTION