DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1503: FROM rcv_transactions_interface RTI, po_line_locations_all PLL

1499: INTO l_pending_rcv_transactions
1500: FROM dual
1501: WHERE EXISTS
1502: ( SELECT 1
1503: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1504: WHERE PLL.po_line_id = p_po_line_id
1505: AND RTI.po_line_location_id = PLL.line_location_id -- JOIN
1506: AND RTI.transaction_status_code = 'PENDING' );
1507:

Line 1723: FROM rcv_transactions_interface RTI

1719: INTO l_pending_rcv_transactions
1720: FROM dual
1721: WHERE EXISTS
1722: ( SELECT 1
1723: FROM rcv_transactions_interface RTI
1724: WHERE RTI.po_line_location_id = p_line_location_id
1725: AND RTI.transaction_status_code = 'PENDING' );
1726:
1727: IF (l_pending_rcv_transactions > 0) THEN