DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on RCV_TRANSACTIONS

Line 838: , rcv_transactions rt

834:
835: SELECT rsh.receipt_num
836: INTO l_receipt_num
837: FROM rcv_shipment_headers rsh
838: , rcv_transactions rt
839: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
840: AND rsh.shipment_header_id = rt.shipment_header_id;
841:
842: end if;

Line 1272: , rcv_transactions rt

1268:
1269: SELECT rsh.receipt_num
1270: INTO l_receipt_num
1271: FROM rcv_shipment_headers rsh
1272: , rcv_transactions rt
1273: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1274: AND rsh.shipment_header_id = rt.shipment_header_id;
1275:
1276: end if;

Line 1711: , rcv_transactions rt

1707:
1708: SELECT rsh.receipt_num
1709: INTO l_receipt_num
1710: FROM rcv_shipment_headers rsh
1711: , rcv_transactions rt
1712: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1713: AND rsh.shipment_header_id = rt.shipment_header_id;
1714:
1715: end if;

Line 2139: , rcv_transactions rt

2135:
2136: SELECT rsh.receipt_num
2137: INTO l_receipt_num
2138: FROM rcv_shipment_headers rsh
2139: , rcv_transactions rt
2140: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
2141: AND rsh.shipment_header_id = rt.shipment_header_id;
2142:
2143: end if;