APPS.ENI_DBI_PCO_LOAD_PKG dependencies on BOM_STRUCTURES_B

Line 68: bom_structures_b bbom

64: bbom.assembly_item_id AS assembly_item_id,
65: bbom.organization_id AS organization_id
66: FROM
67: mlog$_bom_components_b mbic,
68: bom_structures_b bbom
69: WHERE
70: mbic.bill_sequence_id = bbom.bill_sequence_id and
71: bbom.alternate_bom_designator IS NULL and
72: bbom.bill_sequence_id = bbom.common_bill_sequence_id and

Line 73: exists (select 1 from bom_structures_b bbom_common

69: WHERE
70: mbic.bill_sequence_id = bbom.bill_sequence_id and
71: bbom.alternate_bom_designator IS NULL and
72: bbom.bill_sequence_id = bbom.common_bill_sequence_id and
73: exists (select 1 from bom_structures_b bbom_common
74: where bbom_common.common_bill_sequence_id = bbom.bill_sequence_id
75: and bbom_common.organization_id IN
76: (select * from eni_dbi_part_count_org_temp))
77: and mbic.snaptime$$ > NVL(last_collected_date,mbic.snaptime$$)

Line 83: mlog$_bom_structures_b bbom -- Bug # 3394284

79: SELECT UNIQUE
80: bbom.assembly_item_id AS assembly_item_id,
81: bbom.organization_id AS organization_id
82: FROM
83: mlog$_bom_structures_b bbom -- Bug # 3394284
84: WHERE
85: bbom.dmltype$$ <> 'I' and
86: bbom.alternate_bom_designator IS NULL and
87: bbom.bill_sequence_id = bbom.common_bill_sequence_id and

Line 94: mlog$_bom_structures_b mlog_bbom, bom_structures_b bbom

90: SELECT UNIQUE -- Collects any newly commoned bills
91: bbom.assembly_item_id AS assembly_item_id,
92: bbom.organization_id AS organization_id
93: FROM
94: mlog$_bom_structures_b mlog_bbom, bom_structures_b bbom
95: WHERE
96: mlog_bbom.alternate_bom_designator IS NULL and
97: mlog_bbom.bill_sequence_id <> mlog_bbom.common_bill_sequence_id and
98: mlog_bbom.organization_id IN (select * from eni_dbi_part_count_org_temp) and

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 400: -- DELETE FROM mlog$_bom_structures_b;

396: -- Truncate all the temporary tables used.
397: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PCO_WORKER_ASSIGNMENTS';
398: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PART_COUNT_INCR_TEMP';
399: -- DELETE FROM mlog$_bom_components_b;
400: -- DELETE FROM mlog$_bom_structures_b;
401:
402: end cleanup;
403:
404: procedure process_incident_interface_g(

Line 664: FROM BOM_STRUCTURES_B bbom -- Bug # 3394284

660:
661: IF (l_error_code <> 0) OR l_error_msg IS NOT NULL THEN
662: -- Error in Explosion
663: SELECT bbom.bill_sequence_id INTO l_bill_sequence_id
664: FROM BOM_STRUCTURES_B bbom -- Bug # 3394284
665: WHERE bbom.assembly_item_id = l_inventory_item_id
666: AND bbom.organization_id = l_org_id
667: AND bbom.alternate_bom_designator IS NULL
668: AND bbom.bill_sequence_id = bbom.common_bill_sequence_id;