APPS.CSTPOYLD dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 1540: wsm_split_merge_transactions smt

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
1544: UNION

Line 1552: wsm_split_merge_transactions smt,

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

Line 1567: wsm_split_merge_transactions smt

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
1571: and rj.job_operation_seq_num is not NULL

Line 1584: wsm_split_merge_transactions smt,

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
1588: and smt.transaction_type_id = 4