APPS.ENI_DBI_PCO_LOAD_PKG dependencies on MLOG$_BOM_STRUCTURES_B

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 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(