APPS.CSTPSMUT dependencies on WIP_CONSTANTS

Line 326: nvl(starting_intraoperation_step, WIP_CONSTANTS.QUEUE) starting_intraoperation_step,

322:
323: CURSOR c_result_lot IS
324: SELECT start_quantity, wip_entity_id,
325: nvl(starting_operation_seq_num,10) starting_operation_seq_num,
326: nvl(starting_intraoperation_step, WIP_CONSTANTS.QUEUE) starting_intraoperation_step,
327: common_routing_sequence_id
328: FROM wsm_sm_resulting_jobs
329: WHERE transaction_id = p_transaction_id;
330:

Line 1019: nvl(starting_intraoperation_step, WIP_CONSTANTS.QUEUE) starting_intraoperation_step,

1015:
1016: CURSOR c_result_lot IS
1017: SELECT start_quantity, wip_entity_id,
1018: nvl(starting_operation_seq_num,10) starting_operation_seq_num,
1019: nvl(starting_intraoperation_step, WIP_CONSTANTS.QUEUE) starting_intraoperation_step,
1020: common_routing_sequence_id
1021: FROM wsm_sm_resulting_jobs
1022: WHERE transaction_id = p_transaction_id;
1023:

Line 2445: nvl(starting_intraoperation_step, WIP_CONSTANTS.QUEUE),

2441: l_stmt_num := 50;
2442:
2443: SELECT wip_entity_id,
2444: job_operation_seq_num,
2445: nvl(starting_intraoperation_step, WIP_CONSTANTS.QUEUE),
2446: start_quantity
2447: INTO l_wip_entity_id,
2448: l_operation_seq_num,
2449: l_intraoperation_step,