APPS.CSTPOYLD dependencies on WSM_SM_RESULTING_JOBS

Line 508: FROM WSM_SM_RESULTING_JOBS

504:
505: IF (i_run_option = 3 and rec_opseq.operation_seq_num <= i_txn_op_seq_num ) THEN
506: SELECT BONUS_ACCT_ID
507: INTO x_abs_account
508: FROM WSM_SM_RESULTING_JOBS
509: WHERE TRANSACTION_ID = i_sm_txn_id
510: AND WIP_ENTITY_ID = i_entity_id;
511: ELSE
512: x_abs_account := l_est_scrap_abs_acct;

Line 1551: from wsm_sm_resulting_jobs rj,

1547: rj.starting_intraoperation_step intra_op_step,
1548: smt.organization_id organization_id,
1549: rj.common_routing_sequence_id routing_seq_id,
1550: smt.transaction_type_id txn_type_id
1551: from wsm_sm_resulting_jobs rj,
1552: wsm_split_merge_transactions smt,
1553: wsm_sm_starting_jobs sj
1554: where smt.transaction_id = i_txn_id
1555: and smt.transaction_type_id in (1,2,6)

Line 1566: from wsm_sm_resulting_jobs rj,

1562: nvl(rj.starting_intraoperation_step, WIP_CONSTANTS.QUEUE) intra_op_step,
1563: smt.organization_id organization_id,
1564: rj.common_routing_sequence_id routing_seq_id,
1565: smt.transaction_type_id txn_type_id
1566: from wsm_sm_resulting_jobs rj,
1567: wsm_split_merge_transactions smt
1568: where smt.transaction_id = i_txn_id
1569: and smt.transaction_type_id = 4
1570: and smt.transaction_id = rj.transaction_id

Line 1583: from wsm_sm_resulting_jobs rj,

1579: nvl(rj.starting_intraoperation_step, WIP_CONSTANTS.QUEUE) intra_op_step,
1580: smt.organization_id organization_id,
1581: rj.common_routing_sequence_id routing_seq_id,
1582: smt.transaction_type_id txn_type_id
1583: from wsm_sm_resulting_jobs rj,
1584: wsm_split_merge_transactions smt,
1585: wip_operations wo,
1586: bom_operation_sequences bos
1587: where smt.transaction_id = i_txn_id