DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on RCV_TRANSACTIONS

Line 4523: FROM rcv_transactions r,

4519: END IF;
4520: BEGIN
4521: SELECT p.terms_id
4522: INTO l_term_id
4523: FROM rcv_transactions r,
4524: po_headers p,
4525: ap_invoice_lines_interface l
4526: WHERE p.po_header_id = r.po_header_id
4527: AND r.transaction_id = l.rcv_transaction_id

Line 16077: FROM rcv_transactions RT ,

16073: BEGIN
16074: --bug 5118518:Removed the view reference
16075: SELECT nvl(sum(nvl(RT.quantity_billed,0)),0)
16076: INTO l_qty_billed_sum
16077: FROM rcv_transactions RT ,
16078: rcv_shipment_headers SH ,
16079: po_headers_all PH ,
16080: po_line_locations_all PS ,
16081: po_releases_all PR ,

Line 16596: FROM rcv_transactions

16592:
16593: BEGIN
16594: SELECT nvl(quantity_billed,0)
16595: INTO l_qty_billed
16596: FROM rcv_transactions
16597: WHERE transaction_id = p_invoice_lines_rec.rcv_transaction_id;
16598:
16599: IF (l_qty_billed + p_invoice_lines_rec.quantity_invoiced ) < 0 THEN
16600: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(