51: SELECT min(poh.ORG_ID)
52: INTO p_org_id
53: FROM
54: po_headers_all poh,
55: po_lines_all pol,
56: po_line_locations_all pll,
57: Mtl_system_items_kfv msi
58: WHERE
59: poh.SEGMENT1 = p_po_number AND
69: SELECT min(poh.ORG_ID)
70: INTO p_org_id
71: FROM
72: po_headers_all poh,
73: po_lines_all pol,
74: po_line_locations_all pll,
75: po_releases_all prl,
76: Mtl_system_items_kfv msi
77: WHERE
104: into
105: p_ship_to_org_id
106: from
107: po_headers_all poh,
108: po_lines_all pol,
109: po_line_locations_all pll
110: where
111: poh.po_header_id = p_po_header_id and
112: poh.po_header_id = pol.po_header_id and
119: into
120: p_ship_to_org_id
121: from
122: po_headers_all poh,
123: po_lines_all pol,
124: po_line_locations_all pll,
125: po_releases_all prl
126: where
127: poh.po_header_id = p_po_header_id and
251: p_line_location_id,
252: p_ship_to_org_id
253: FROM
254: po_headers_all poh,
255: po_lines_all pol,
256: po_line_locations_all pll,
257: MTL_SYSTEM_ITEMS_KFV MSI
258: WHERE
259: POH.PO_HEADER_ID = POL.PO_HEADER_ID
285: p_ship_to_org_id,
286: p_po_release_id
287: FROM
288: po_headers_all poh,
289: po_lines_all pol,
290: po_line_locations_all pll,
291: po_releases_all prl,
292: MTL_SYSTEM_ITEMS_KFV MSI
293: WHERE