APPS.CSTPSMUT dependencies on WSM_SM_STARTING_JOBS

Line 320: FROM wsm_sm_starting_jobs

316:
317:
318: CURSOR c_start_lot IS
319: SELECT available_quantity, wip_entity_id
320: FROM wsm_sm_starting_jobs
321: WHERE transaction_id = p_transaction_id;
322:
323: CURSOR c_result_lot IS
324: SELECT start_quantity, wip_entity_id,

Line 337: FROM wsm_sm_starting_jobs

333: FROM wsm_sm_resulting_jobs
334: WHERE transaction_id = p_transaction_id
335: AND wip_entity_id not in
336: ( SELECT wip_entity_id
337: FROM wsm_sm_starting_jobs
338: WHERE transaction_id = p_transaction_id );
339:
340:
341: BEGIN

Line 415: FROM WSM_SM_STARTING_JOBS

411: l_operation_seq_num,
412: l_intraoperation_step,
413: l_job_start_quantity,
414: l_available_quantity
415: FROM WSM_SM_STARTING_JOBS
416: WHERE transaction_id = p_transaction_id
417: AND representative_flag = 'Y';
418:
419:

Line 1013: FROM wsm_sm_starting_jobs

1009:
1010:
1011: CURSOR c_start_lot IS
1012: SELECT available_quantity, wip_entity_id
1013: FROM wsm_sm_starting_jobs
1014: WHERE transaction_id = p_transaction_id;
1015:
1016: CURSOR c_result_lot IS
1017: SELECT start_quantity, wip_entity_id,

Line 1030: FROM wsm_sm_starting_jobs

1026: FROM wsm_sm_resulting_jobs
1027: WHERE transaction_id = p_transaction_id
1028: AND wip_entity_id not in
1029: ( SELECT wip_entity_id
1030: FROM wsm_sm_starting_jobs
1031: WHERE transaction_id = p_transaction_id );
1032:
1033: BEGIN
1034:

Line 1105: FROM WSM_SM_STARTING_JOBS

1101: l_operation_seq_num,
1102: l_intraoperation_step,
1103: l_job_start_quantity,
1104: l_available_quantity
1105: FROM WSM_SM_STARTING_JOBS
1106: WHERE transaction_id = p_transaction_id
1107: AND representative_flag = 'Y';
1108:
1109: SELECT wip_entity_id

Line 1903: FROM WSM_SM_STARTING_JOBS

1899: l_operation_seq_num,
1900: l_intraoperation_step,
1901: l_available_quantity,
1902: l_job_start_quantity
1903: FROM WSM_SM_STARTING_JOBS
1904: WHERE transaction_id = p_transaction_id;
1905:
1906: /* Get Information from WSRJ */
1907:

Line 3380: FROM wsm_sm_starting_jobs

3376: FROM wsm_sm_resulting_jobs
3377: WHERE transaction_id = p_txn_id;
3378:
3379: CURSOR C_SJ IS SELECT *
3380: FROM wsm_sm_starting_jobs
3381: WHERE transaction_id = p_txn_id;
3382:
3383:
3384: BEGIN

Line 3579: /* Obtain Information from WSM_SM_STARTING_JOBS

3575: x_err_code := NULL;
3576:
3577: ELSE
3578: /* Update Quantity/Split/Merge */
3579: /* Obtain Information from WSM_SM_STARTING_JOBS
3580: for representative Lot. */
3581: l_stmt_num := 60;
3582:
3583: SELECT operation_seq_num,

Line 3593: FROM WSM_SM_STARTING_JOBS

3589: l_intraoperation_step,
3590: l_rep_wip_entity_id,
3591: l_available_quantity,
3592: l_job_start_quantity
3593: FROM WSM_SM_STARTING_JOBS
3594: WHERE transaction_id = p_txn_id
3595: AND representative_flag = 'Y';
3596:
3597: FOR C_rec IN C_RJ LOOP