eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPACDP dependencies on RCV_TRANSACTIONS

Line 741: FROM rcv_transactions

737:
738: l_stmt_num := 43;
739: SELECT po_distribution_id
740: INTO l_loc_po_distribution_id
741: FROM rcv_transactions
742: WHERE transaction_id =l_rcv_transaction_id;
743:
744: IF l_debug = 'Y' THEN
745: fnd_file.put_line(fnd_file.log, 'Calling CST_Common_hooks.Get_NRtax_amount for PO_DIST :'||l_loc_po_distribution_id);

Line 1921: from rcv_transactions rt, mtl_material_transactions mmt

1917:
1918: l_stmt_num := 35;
1919: select rt.dropship_type_code
1920: into l_drop_ship_type_code
1921: from rcv_transactions rt, mtl_material_transactions mmt
1922: where rt.transaction_id = mmt.rcv_transaction_id
1923: and mmt.transaction_id = i_txn_id;
1924:
1925: if (l_drop_ship_type_code = 1 OR l_drop_ship_type_code = 2) then

Line 6735: rcv_transactions rt,

6731: l_stmt_num := 3;
6732: SELECT rsl.ussgl_transaction_code
6733: INTO l_ussgl_tc
6734: FROM mtl_material_transactions mmt,
6735: rcv_transactions rt,
6736: rcv_shipment_lines rsl
6737: WHERE mmt.transaction_id = i_txn_id
6738: AND mmt.rcv_transaction_id = rt.transaction_id
6739: AND rt.shipment_line_id = rsl.shipment_line_id;

Line 6747: rcv_transactions rt,

6743: l_stmt_num := 4;
6744: SELECT POD.ussgl_transaction_code, nvl(pod.rate,1), pod.rate_date, poh.rate_type
6745: INTO l_ussgl_tc, l_conv_rate, l_conv_date, l_conv_type
6746: FROM mtl_material_transactions mmt,
6747: rcv_transactions rt,
6748: po_distributions_all pod,
6749: po_headers_all poh
6750: WHERE mmt.transaction_id = i_txn_id
6751: AND mmt.rcv_transaction_id = rt.transaction_id