DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on RCV_TRANSACTIONS

Line 328: rcv_transactions rt,

324: cursor receipt_info_cursor is
325: --using lines for matching
326: select distinct rsh.receipt_num, rsh.SHIPMENT_HEADER_ID
327: from ap_invoice_lines_all al,
328: rcv_transactions rt,
329: rcv_shipment_headers rsh
330: where al.invoice_id = l_invoice_id
331: and al.rcv_transaction_id = rt.transaction_id
332: and rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID;

Line 337: rcv_transactions rt,

333:
334: --using distributions for matching
335: /* SELECT distinct rsh.SHIPMENT_HEADER_ID, rsh.receipt_num
336: FROM ap_invoice_distributions_all aid,
337: rcv_transactions rt,
338: rcv_shipment_headers rsh
339: WHERE aid.invoice_id = l_invoice_id
340: and aid.rcv_transaction_id = rt.transaction_id
341: and rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID;