DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on RCV_TRANSACTIONS

Line 766: , rcv_transactions rt

762:
763: SELECT rsh.receipt_num
764: INTO l_receipt_num
765: FROM rcv_shipment_headers rsh
766: , rcv_transactions rt
767: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
768: AND rsh.shipment_header_id = rt.shipment_header_id;
769:
770: end if;

Line 1134: , rcv_transactions rt

1130:
1131: SELECT rsh.receipt_num
1132: INTO l_receipt_num
1133: FROM rcv_shipment_headers rsh
1134: , rcv_transactions rt
1135: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1136: AND rsh.shipment_header_id = rt.shipment_header_id;
1137:
1138: end if;

Line 1509: , rcv_transactions rt

1505:
1506: SELECT rsh.receipt_num
1507: INTO l_receipt_num
1508: FROM rcv_shipment_headers rsh
1509: , rcv_transactions rt
1510: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1511: AND rsh.shipment_header_id = rt.shipment_header_id;
1512:
1513: end if;

Line 1874: , rcv_transactions rt

1870:
1871: SELECT rsh.receipt_num
1872: INTO l_receipt_num
1873: FROM rcv_shipment_headers rsh
1874: , rcv_transactions rt
1875: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1876: AND rsh.shipment_header_id = rt.shipment_header_id;
1877:
1878: end if;