DBA Data[Home] [Help]

APPS.ENI_DBI_PCO_LOAD_PKG dependencies on MLOG$_BOM_COMPONENTS_B

Line 67: mlog$_bom_components_b mbic,

63: SELECT UNIQUE -- Collects all modified common/non-common bills whose orgs are in org temp table
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

Line 399: -- DELETE FROM mlog$_bom_components_b;

395:
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: