DBA Data[Home] [Help]

APPS.RCV_SEEDEVENTS_PVT dependencies on PO_HEADERS

Line 239: po_headers POH

235: FROM ap_invoice_distributions APID,
236: po_distributions POD,
237: po_line_locations POLL,
238: po_lines POL,
239: po_headers POH
240: WHERE APID.invoice_distribution_id = p_inv_distribution_id
241: AND POD.po_distribution_id = APID.po_distribution_id
242: AND POD.line_location_id = POLL.line_location_id
243: AND POL.po_line_id = POLL.po_line_id

Line 287: po_headers POH,

283: l_rcv_event.unit_landed_cost
284: FROM rcv_transactions RT,
285: po_lines POL,
286: po_line_locations POLL,
287: po_headers POH,
288: po_distributions POD
289: WHERE RT.transaction_id = p_rcv_transaction_id
290: AND POH.po_header_id = RT.po_header_id
291: AND POL.po_line_id = RT.po_line_id

Line 2249: po_headers POH

2245: INTO l_currency_conversion_rate,
2246: l_currency_conversion_type,
2247: l_currency_conversion_date
2248: FROM po_distributions POD,
2249: po_headers POH
2250: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id
2251: AND POH.po_header_id = POD.po_header_id;
2252:
2253: ELSE