DBA Data[Home] [Help]

APPS.CSTPOYLD dependencies on WSM_SM_STARTING_JOBS

Line 1539: FROM wsm_sm_starting_jobs sj,

1535: sj.intraoperation_step intra_op_step,
1536: smt.organization_id organization_id,
1537: sj.routing_seq_id routing_seq_id,
1538: smt.transaction_type_id txn_type_id
1539: FROM wsm_sm_starting_jobs sj,
1540: wsm_split_merge_transactions smt
1541: WHERE smt.transaction_id = i_txn_id
1542: AND smt.transaction_type_id In (1, 2, 6)
1543: AND smt.transaction_id = sj.transaction_id

Line 1553: wsm_sm_starting_jobs sj

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)
1556: and smt.transaction_id = rj.transaction_id
1557: and smt.transaction_id = sj.transaction_id