APPS.BOMPIMPL dependencies on BOM_IMPLOSION_TEMP

Line 20: INSERT INTO BOM_IMPLOSION_TEMP

16: a_err_code NUMBER;
17:
18: BEGIN
19:
20: INSERT INTO BOM_IMPLOSION_TEMP
21: ( SEQUENCE_ID,
22: LOWEST_ITEM_ID,
23: CURRENT_ITEM_ID,
24: PARENT_ITEM_ID,

Line 151: BOM_IMPLOSION_TEMP BITT,

147: BIC.CHANGE_NOTICE CN,
148: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
149: BBM.ORGANIZATION_ID OI
150: FROM
151: BOM_IMPLOSION_TEMP BITT,
152: BOM_INVENTORY_COMPONENTS BIC,
153: BOM_BILL_OF_MATERIALS BBM
154: where bic.pk1_value = BITT.PARENT_ITEM_ID -- 8470695
155: and bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id) -- 8470695

Line 376: INSERT INTO BOM_IMPLOSION_TEMP

372: cat_sort := lpad(total_rows, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');
373:
374: impl_row.SC := impl_row.SC || cat_sort;
375:
376: INSERT INTO BOM_IMPLOSION_TEMP
377: (LOWEST_ITEM_ID,
378: CURRENT_ITEM_ID,
379: PARENT_ITEM_ID,
380: ALTERNATE_DESIGNATOR,

Line 492: BOM_IMPLOSION_TEMP BITT,

488: BIC.CHANGE_NOTICE CN,
489: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
490: BBM.ORGANIZATION_ID OI
491: FROM
492: BOM_IMPLOSION_TEMP BITT,
493: BOM_INVENTORY_COMPONENTS BIC,
494: BOM_BILL_OF_MATERIALS BBM
495: where bic.pk1_value = BITT.PARENT_ITEM_ID
496: and bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id)

Line 714: INSERT INTO BOM_IMPLOSION_TEMP

710: cat_sort := lpad(cum_count, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');
711:
712: impl_row.SC := impl_row.SC || cat_sort;
713:
714: INSERT INTO BOM_IMPLOSION_TEMP
715: (LOWEST_ITEM_ID,
716: CURRENT_ITEM_ID,
717: PARENT_ITEM_ID,
718: ALTERNATE_DESIGNATOR,