APPS.CSTPLENG dependencies on RCV_TRANSACTIONS

Line 1747: rcv_transactions rt1,

1743: decode(rt2.parent_transaction_id,-1,rt2.transaction_id,rt2.parent_transaction_id)
1744: INTO l_last_txn_type_id,
1745: l_last_rcv_txn_id
1746: FROM mtl_material_transactions mmt,
1747: rcv_transactions rt1,
1748: rcv_transactions rt2
1749: WHERE mmt.transaction_id = l_last_txn_id
1750: AND mmt.rcv_transaction_id = rt1.transaction_id (+)
1751: AND rt1.parent_transaction_id = rt2.transaction_id (+);

Line 1748: rcv_transactions rt2

1744: INTO l_last_txn_type_id,
1745: l_last_rcv_txn_id
1746: FROM mtl_material_transactions mmt,
1747: rcv_transactions rt1,
1748: rcv_transactions rt2
1749: WHERE mmt.transaction_id = l_last_txn_id
1750: AND mmt.rcv_transaction_id = rt1.transaction_id (+)
1751: AND rt1.parent_transaction_id = rt2.transaction_id (+);
1752:

Line 1770: rcv_transactions rt1,

1766: decode(rt2.parent_transaction_id,-1,rt2.transaction_id,rt2.parent_transaction_id)
1767: INTO l_txn_type_id,
1768: l_rcv_txn_id
1769: FROM mtl_material_transactions mmt,
1770: rcv_transactions rt1,
1771: rcv_transactions rt2
1772: WHERE mmt.transaction_id = i_txn_id
1773: AND mmt.rcv_transaction_id = rt1.transaction_id (+)
1774: AND rt1.parent_transaction_id = rt2.transaction_id (+);

Line 1771: rcv_transactions rt2

1767: INTO l_txn_type_id,
1768: l_rcv_txn_id
1769: FROM mtl_material_transactions mmt,
1770: rcv_transactions rt1,
1771: rcv_transactions rt2
1772: WHERE mmt.transaction_id = i_txn_id
1773: AND mmt.rcv_transaction_id = rt1.transaction_id (+)
1774: AND rt1.parent_transaction_id = rt2.transaction_id (+);
1775:

Line 3159: rcv_transactions rt_rtr

3155: SELECT mmt_del.transaction_id
3156: INTO l_rtr_txn_id
3157: FROM mtl_material_transactions mmt_del,
3158: mtl_material_transactions mmt_rtr,
3159: rcv_transactions rt_rtr
3160: WHERE mmt_del.rcv_transaction_id = rt_rtr.parent_transaction_id
3161: AND rt_rtr.transaction_id = mmt_rtr.rcv_transaction_id
3162: AND mmt_rtr.transaction_id = i_txn_id;
3163: EXCEPTION