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 3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;

3336: EXCEPTION WHEN NO_DATA_FOUND
3337: THEN
3338: -- Insert for plan level 0
3339:
3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3341:
3342: insert INTO BOM_EXPLOSIONS_ALL
3343: (
3344: group_id,