DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_HEADERS

Line 64: RCV_SHIPMENT_HEADERS RSH

60: po_line_locations pll,
61: po_lines pl,
62: po_headers ph,
63: RCV_SHIPMENT_LINES RSL,
64: RCV_SHIPMENT_HEADERS RSH
65: WHERE
66: rsh.shipment_header_id = v_shipment_header_id
67: and rsl.shipment_header_id = rsh.shipment_header_id
68: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 126: RCV_SHIPMENT_HEADERS RSH

122: FROM po_line_locations pll,
123: po_lines pl,
124: po_headers ph,
125: RCV_SHIPMENT_LINES RSL,
126: RCV_SHIPMENT_HEADERS RSH
127: WHERE
128: rsh.shipment_header_id = v_shipment_header_id
129: and rsl.shipment_header_id = rsh.shipment_header_id
130: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 233: RCV_SHIPMENT_HEADERS RSH

229: po_line_locations pll,
230: po_lines pl,
231: po_headers ph,
232: RCV_SHIPMENT_LINES RSL,
233: RCV_SHIPMENT_HEADERS RSH
234: WHERE
235: rsh.shipment_header_id = v_shipment_header_id
236: and rsl.shipment_header_id = rsh.shipment_header_id
237: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)

Line 300: RCV_SHIPMENT_HEADERS RSH

296: po_line_locations pll,
297: po_lines pl,
298: po_headers ph,
299: RCV_SHIPMENT_LINES RSL,
300: RCV_SHIPMENT_HEADERS RSH
301: WHERE
302: rsh.shipment_header_id = v_shipment_header_id
303: and rsl.shipment_header_id = rsh.shipment_header_id
304: and rsl.shipment_line_id = nvl(v_shipment_line_id,rsl.shipment_line_id)