DBA Data[Home] [Help]

APPS.RCV_SEEDEVENTS_PVT dependencies on AP_INVOICE_DISTRIBUTIONS

Line 235: FROM ap_invoice_distributions APID,

231: l_rcv_event.item_id,
232: l_rcv_event.source_doc_quantity,
233: l_rcv_event.source_doc_uom,
234: l_rcv_event.currency_code
235: FROM ap_invoice_distributions APID,
236: po_distributions POD,
237: po_line_locations POLL,
238: po_lines POL,
239: po_headers POH

Line 797: FROM ap_invoice_distributions APID

793: -- For source of invoice match, there will always be a po_distribution_id
794: l_stmt_num := 20;
795: SELECT APID.amount
796: INTO l_transaction_amount
797: FROM ap_invoice_distributions APID
798: WHERE APID.invoice_distribution_id = p_rcv_event.inv_distribution_id;
799:
800: END IF;
801:

Line 1500: FROM ap_invoice_distributions APID

1496: ELSIF (p_rcv_event.event_source = 'INVOICEMATCH') THEN
1497: l_stmt_num := 80;
1498: SELECT APID.unit_price
1499: INTO l_unit_price
1500: FROM ap_invoice_distributions APID
1501: WHERE APID.invoice_distribution_id = p_rcv_event.inv_distribution_id;
1502: END IF;
1503:
1504: x_intercompany_pricing_option := l_ic_pricing_option;