DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_HEADERS

Line 66: RCV_SHIPMENT_HEADERS RSH

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
69: and rsl.shipment_header_id = rsh.shipment_header_id
70: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 128: RCV_SHIPMENT_HEADERS RSH

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
131: and rsl.shipment_header_id = rsh.shipment_header_id
132: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 237: RCV_SHIPMENT_HEADERS RSH

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
240: and rsl.shipment_header_id = rsh.shipment_header_id
241: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 304: RCV_SHIPMENT_HEADERS RSH

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
307: and rsl.shipment_header_id = rsh.shipment_header_id
308: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)