DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on PO_HEADERS

Line 64: po_headers ph,

60: rsl.item_id -- pl.item_id
61: FROM
62: po_line_locations pll,
63: po_lines pl,
64: po_headers ph,
65: RCV_SHIPMENT_LINES RSL,
66: RCV_SHIPMENT_HEADERS RSH
67: WHERE
68: rsh.shipment_header_id = v_shipment_header_id

Line 126: po_headers ph,

122: IS
123: SELECT COUNT(*)
124: FROM po_line_locations pll,
125: po_lines pl,
126: po_headers ph,
127: RCV_SHIPMENT_LINES RSL,
128: RCV_SHIPMENT_HEADERS RSH
129: WHERE
130: rsh.shipment_header_id = v_shipment_header_id

Line 235: po_headers ph,

231: FROM
232: po_distributions pod,
233: po_line_locations pll,
234: po_lines pl,
235: po_headers ph,
236: RCV_SHIPMENT_LINES RSL,
237: RCV_SHIPMENT_HEADERS RSH
238: WHERE
239: rsh.shipment_header_id = v_shipment_header_id

Line 302: po_headers ph,

298: FROM
299: po_distributions pod,
300: po_line_locations pll,
301: po_lines pl,
302: po_headers ph,
303: RCV_SHIPMENT_LINES RSL,
304: RCV_SHIPMENT_HEADERS RSH
305: WHERE
306: rsh.shipment_header_id = v_shipment_header_id