DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on BOM_EXPLOSIONS_ALL_S

Line 14: | use value FROM sequence BOM_EXPLOSIONS_ALL_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_EXPLOSIONS_ALL_s
15: | session_id unique value to identify current session
16: | use value FROM BOM_EXPLOSIONS_ALL_session_s
17: | levels_to_explode
18: | bom_or_eng 1 - BOM

Line 16: | use value FROM BOM_EXPLOSIONS_ALL_session_s

12: | 2 - Item seq, op seq
13: | grp_id unique value to identify current explosion
14: | use value FROM sequence BOM_EXPLOSIONS_ALL_s
15: | session_id unique value to identify current session
16: | use value FROM BOM_EXPLOSIONS_ALL_session_s
17: | levels_to_explode
18: | bom_or_eng 1 - BOM
19: | 2 - ENG
20: | impl_flag 1 - implemented only

Line 3226: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;

3222: EXCEPTION WHEN NO_DATA_FOUND
3223: THEN
3224: -- Insert for plan level 0
3225:
3226: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3227:
3228: insert INTO BOM_EXPLOSIONS_ALL
3229: (
3230: group_id,