DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on RCV_TRANSACTIONS

Line 330: rcv_transactions rt,

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

Line 339: rcv_transactions rt,

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