APPS.CSTPACDP dependencies on RCV_TRANSACTIONS

Line 652: FROM rcv_transactions

648:
649: l_stmt_num := 43;
650: SELECT po_distribution_id
651: INTO l_loc_po_distribution_id
652: FROM rcv_transactions
653: WHERE transaction_id =l_rcv_transaction_id;
654:
655: IF l_debug = 'Y' THEN
656: fnd_file.put_line(fnd_file.log, 'Calling CST_Common_hooks.Get_NRtax_amount for PO_DIST :'||l_loc_po_distribution_id);

Line 1830: from rcv_transactions rt, mtl_material_transactions mmt

1826:
1827: l_stmt_num := 35;
1828: select rt.dropship_type_code
1829: into l_drop_ship_type_code
1830: from rcv_transactions rt, mtl_material_transactions mmt
1831: where rt.transaction_id = mmt.rcv_transaction_id
1832: and mmt.transaction_id = i_txn_id;
1833:
1834: if (l_drop_ship_type_code = 1 OR l_drop_ship_type_code = 2) then

Line 6614: rcv_transactions rt,

6610: l_stmt_num := 3;
6611: SELECT rsl.ussgl_transaction_code
6612: INTO l_ussgl_tc
6613: FROM mtl_material_transactions mmt,
6614: rcv_transactions rt,
6615: rcv_shipment_lines rsl
6616: WHERE mmt.transaction_id = i_txn_id
6617: AND mmt.rcv_transaction_id = rt.transaction_id
6618: AND rt.shipment_line_id = rsl.shipment_line_id;

Line 6626: rcv_transactions rt,

6622: l_stmt_num := 4;
6623: SELECT POD.ussgl_transaction_code
6624: INTO l_ussgl_tc
6625: FROM mtl_material_transactions mmt,
6626: rcv_transactions rt,
6627: po_distributions_all pod
6628: WHERE mmt.transaction_id = i_txn_id
6629: AND mmt.rcv_transaction_id = rt.transaction_id
6630: AND pod.po_distribution_id = rt.po_distribution_id;