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 1493: FROM ap_invoice_distributions APID

1489: ELSIF (p_rcv_event.event_source = 'INVOICEMATCH') THEN
1490: l_stmt_num := 80;
1491: SELECT APID.unit_price
1492: INTO l_unit_price
1493: FROM ap_invoice_distributions APID
1494: WHERE APID.invoice_distribution_id = p_rcv_event.inv_distribution_id;
1495: END IF;
1496:
1497: x_intercompany_pricing_option := l_ic_pricing_option;