DBA Data[Home] [Help]

APPS.BOMPBEXP dependencies on BOM_EXPLOSION_TEMP

Line 14: | use value from sequence bom_explosion_temp_s|

10: | Parameters: org_id organization_id |
11: | order_by 1 - Op seq, item seq |
12: | 2 - Item seq, op seq |
13: | grp_id unique value to identify current explosion |
14: | use value from sequence bom_explosion_temp_s|
15: | levels_to_explode |
16: | bom_or_eng 1 - BOM |
17: | 2 - ENG |
18: | impl_flag 1 - implemented only |

Line 134: FROM BOM_EXPLOSION_TEMP BET,

130: BIC.INCLUDE_ON_SHIP_DOCS IOSD,
131: BIC.LOW_QUANTITY LQ,
132: BIC.HIGH_QUANTITY HQ,
133: BIC.SO_BASIS SB
134: FROM BOM_EXPLOSION_TEMP BET,
135: BOM_BILL_OF_MATERIALS BOM,
136: BOM_INVENTORY_COMPONENTS BIC,
137: MTL_SYSTEM_ITEMS MSI
138: WHERE BET.PLAN_LEVEL = c_level - 1

Line 405: INSERT INTO BOM_EXPLOSION_TEMP (

401:
402: End loop;
403: End if;
404:
405: INSERT INTO BOM_EXPLOSION_TEMP (
406: TOP_BILL_SEQUENCE_ID,
407: BILL_SEQUENCE_ID,
408: COMMON_BILL_SEQUENCE_ID,
409: ORGANIZATION_ID,