APPS.AP_IMPORT_VALIDATION_PKG dependencies on RCV_TRANSACTIONS

Line 4256: FROM rcv_transactions r,

4252: END IF;
4253: BEGIN
4254: SELECT p.terms_id
4255: INTO l_term_id
4256: FROM rcv_transactions r,
4257: po_headers p,
4258: ap_invoice_lines_interface l
4259: WHERE p.po_header_id = r.po_header_id
4260: AND r.transaction_id = l.rcv_transaction_id

Line 14683: FROM rcv_transactions RT ,

14679: BEGIN
14680: --bug 5118518:Removed the view reference
14681: SELECT nvl(sum(nvl(RT.quantity_billed,0)),0)
14682: INTO l_qty_billed_sum
14683: FROM rcv_transactions RT ,
14684: rcv_shipment_headers SH ,
14685: po_headers_all PH ,
14686: po_line_locations_all PS ,
14687: po_releases_all PR ,

Line 15201: FROM rcv_transactions

15197:
15198: BEGIN
15199: SELECT nvl(quantity_billed,0)
15200: INTO l_qty_billed
15201: FROM rcv_transactions
15202: WHERE transaction_id = p_invoice_lines_rec.rcv_transaction_id;
15203:
15204: IF (l_qty_billed + p_invoice_lines_rec.quantity_invoiced ) < 0 THEN
15205: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(