DBA Data[Home] [Help]

APPS.GMD_QA_RCV_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 23: rcv_shipment_headers rsh

19: --po_line_locations_all poll,
20: rcv_transactions rcv ,
21: gmd_sampling_events se,
22: rcv_shipment_lines rsl,
23: rcv_shipment_headers rsh
24: where
25: -- segment1 = p_po_num
26: --and poh.po_header_id = pol.po_header_id
27: --and rsl.line_num = p_po_line_num

Line 50: rcv_shipment_headers rsh

46: po_line_locations_all poll,
47: rcv_transactions rcv ,
48: gmd_sampling_events se,
49: rcv_shipment_lines rsl,
50: rcv_shipment_headers rsh
51: where
52: segment1 = p_po_num
53: and poh.po_header_id = pol.po_header_id
54: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028 take this out

Line 141: rcv_shipment_headers rsh

137: --po_line_locations_all poll,
138: rcv_transactions rcv ,
139: gmd_sampling_events se,
140: rcv_shipment_lines rsl,
141: rcv_shipment_headers rsh
142: where
143: -- segment1 = p_po_num
144: --and poh.po_header_id = pol.po_header_id
145: --and rsl.line_num = p_po_line_num

Line 167: rcv_shipment_headers rsh

163: po_line_locations_all poll,
164: rcv_transactions rcv ,
165: gmd_sampling_events se,
166: rcv_shipment_lines rsl,
167: rcv_shipment_headers rsh
168: where
169: segment1 = p_po_num
170: and poh.po_header_id = pol.po_header_id
171: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028

Line 256: rcv_shipment_headers rsh

252: --po_line_locations_all poll,
253: rcv_transactions rcv ,
254: gmd_sampling_events se,
255: rcv_shipment_lines rsl,
256: rcv_shipment_headers rsh
257: where
258: -- segment1 = p_po_num
259: --and poh.po_header_id = pol.po_header_id
260: --and rsl.line_num = p_po_line_num

Line 283: rcv_shipment_headers rsh

279: po_line_locations_all poll,
280: rcv_transactions rcv ,
281: gmd_sampling_events se,
282: rcv_shipment_lines rsl,
283: rcv_shipment_headers rsh
284: where
285: segment1 = p_po_num
286: and poh.po_header_id = pol.po_header_id
287: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028

Line 425: rcv_shipment_headers rsh

421: po_line_locations_all poll,
422: rcv_transactions rcv ,
423: gmd_sampling_events se,
424: rcv_shipment_lines rsl,
425: rcv_shipment_headers rsh
426: where segment1 = p_po_num
427: and poh.po_header_id = pol.po_header_id
428: --and rsl.line_num = p_shipment_num --p_po_line_num - CHANGED FOR 14249028
429: and pol.line_num = p_po_line_num