APPS.CSTPSMUT dependencies on WSM_SM_RESULTING_JOBS

Line 328: FROM wsm_sm_resulting_jobs

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:
331: CURSOR c_new_jobs IS
332: SELECT wip_entity_id

Line 333: FROM wsm_sm_resulting_jobs

329: WHERE transaction_id = p_transaction_id;
330:
331: CURSOR c_new_jobs IS
332: SELECT wip_entity_id
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

Line 424: FROM WSM_SM_RESULTING_JOBS

420: /* Obtain Total Resulting Quantity */
421: l_stmt_num := 60;
422: SELECT SUM(start_quantity)
423: INTO l_total_resulting_qty
424: FROM WSM_SM_RESULTING_JOBS
425: WHERE transaction_id = p_transaction_id;
426:
427:
428: /* Get the Job Charges */

Line 1021: FROM wsm_sm_resulting_jobs

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:
1024: CURSOR c_new_jobs IS
1025: SELECT wip_entity_id

Line 1026: FROM wsm_sm_resulting_jobs

1022: WHERE transaction_id = p_transaction_id;
1023:
1024: CURSOR c_new_jobs IS
1025: SELECT wip_entity_id
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

Line 1111: FROM wsm_sm_resulting_jobs

1107: AND representative_flag = 'Y';
1108:
1109: SELECT wip_entity_id
1110: INTO l_result_wip_entity_id
1111: FROM wsm_sm_resulting_jobs
1112: WHERE transaction_id = p_transaction_id;
1113:
1114:
1115: /* Get the Job Charges */

Line 1912: FROM WSM_SM_RESULTING_JOBS

1908: l_stmt_num := 60;
1909:
1910: SELECT start_quantity
1911: INTO l_start_quantity
1912: FROM WSM_SM_RESULTING_JOBS
1913: WHERE transaction_id = p_transaction_id;
1914:
1915:
1916: /* Get the Job Charges */

Line 2451: FROM WSM_SM_RESULTING_JOBS

2447: INTO l_wip_entity_id,
2448: l_operation_seq_num,
2449: l_intraoperation_step,
2450: l_start_quantity
2451: FROM WSM_SM_RESULTING_JOBS
2452: WHERE transaction_id = p_transaction_id;
2453:
2454: /* Scenario applicable for jobs that are upgraded
2455: from 11i.8 and below. JOB_OPERATION_SEQ_NUM is not

Line 2465: WSM_SM_RESULTING_JOBS WSRJ,

2461: l_stmt_num := 52;
2462: SELECT wo.operation_seq_num
2463: INTO l_operation_seq_num
2464: FROM WIP_OPERATIONS WO,
2465: WSM_SM_RESULTING_JOBS WSRJ,
2466: BOM_OPERATION_SEQUENCES BOS
2467: WHERE WSRJ.transaction_id = p_transaction_id
2468: AND nvl(wsrj.starting_intraoperation_step, 1) = 1
2469: AND wsrj.common_routing_sequence_id = bos.routing_sequence_id

Line 3376: FROM wsm_sm_resulting_jobs

3372: l_resulting_scale_factor NUMBER := 0;
3373: l_include_comp_yield NUMBER;
3374:
3375: CURSOR C_RJ IS SELECT *
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

Line 3446: WSM_SM_RESULTING_JOBS WSRJ,

3442: IF l_operation_seq_num IS NULL THEN
3443: SELECT wo.operation_seq_num
3444: INTO l_operation_seq_num
3445: FROM WIP_OPERATIONS WO,
3446: WSM_SM_RESULTING_JOBS WSRJ,
3447: BOM_OPERATION_SEQUENCES BOS
3448: WHERE WSRJ.transaction_id = p_txn_id
3449: AND nvl(wsrj.starting_intraoperation_step, 1) = 1
3450: AND wsrj.common_routing_sequence_id = bos.routing_sequence_id

Line 3927: FROM wsm_sm_resulting_jobs

3923: SELECT 1
3924: INTO l_resulting_job
3925: FROM sys.dual
3926: WHERE EXISTS (SELECT 1
3927: FROM wsm_sm_resulting_jobs
3928: WHERE transaction_id = p_txn_id
3929: AND wip_entity_id = S_rec.wip_entity_id);
3930: EXCEPTION
3931: WHEN NO_DATA_FOUND THEN

Line 4724: FROM wsm_sm_resulting_jobs

4720: p_program_id, sysdate, primary_item_id,
4721: p_org_id, p_date, p_wip_id,
4722: 5, NULL, p_acct_ltype, 1,
4723: ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit
4724: FROM wsm_sm_resulting_jobs
4725: WHERE transaction_id = p_sm_txn_id
4726: HAVING ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit <> 0;
4727: l_rows_inserted := SQL%ROWCOUNT;
4728:

Line 4793: FROM wsm_sm_resulting_jobs res

4789: p_login_id, p_request_id, p_prog_appl_id, p_program_id,
4790: sysdate, p_org_id, p_date,
4791: p_wip_id, p_acct_ltype,
4792: NVL(ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit,0)
4793: FROM wsm_sm_resulting_jobs res
4794: WHERE res.transaction_id = p_sm_txn_id
4795: HAVING NVL(ROUND(p_total_cost/p_min_acct_unit)*p_min_acct_unit,0) <> 0;
4796:
4797: UPDATE WIP_TRANSACTION_ACCOUNTS