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 146: BOM_IMPLOSION_TEMP BITT,

142: BIC.CHANGE_NOTICE CN,
143: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
144: BBM.ORGANIZATION_ID OI
145: FROM
146: BOM_IMPLOSION_TEMP BITT,
147: BOM_INVENTORY_COMPONENTS BIC,
148: BOM_BILL_OF_MATERIALS BBM
149: where bitt.current_level = 0
150: and bitt.organization_id = c_org_id

Line 369: INSERT INTO BOM_IMPLOSION_TEMP

365: cat_sort := lpad(total_rows, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');
366:
367: impl_row.SC := impl_row.SC || cat_sort;
368:
369: INSERT INTO BOM_IMPLOSION_TEMP
370: (LOWEST_ITEM_ID,
371: CURRENT_ITEM_ID,
372: PARENT_ITEM_ID,
373: ALTERNATE_DESIGNATOR,

Line 480: BOM_IMPLOSION_TEMP BITT,

476: BIC.CHANGE_NOTICE CN,
477: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
478: BBM.ORGANIZATION_ID OI
479: FROM
480: BOM_IMPLOSION_TEMP BITT,
481: BOM_INVENTORY_COMPONENTS BIC,
482: BOM_BILL_OF_MATERIALS BBM
483: where
484: bitt.current_level = c_current_level

Line 701: INSERT INTO BOM_IMPLOSION_TEMP

697: cat_sort := lpad(cum_count, Bom_Common_Definitions.G_Bom_SortCode_Width, '0');
698:
699: impl_row.SC := impl_row.SC || cat_sort;
700:
701: INSERT INTO BOM_IMPLOSION_TEMP
702: (LOWEST_ITEM_ID,
703: CURRENT_ITEM_ID,
704: PARENT_ITEM_ID,
705: ALTERNATE_DESIGNATOR,