13: SELECT
14: SEGMENT1
15: INTO V_PO_NUM
16: FROM
17: PO_HEADERS_ALL
18: WHERE PO_HEADER_ID = V_PO_HEADER_ID;
19: RETURN (V_PO_NUM);
20: RETURN NULL;
21: EXCEPTION
38: SELECT
39: SHIP_TO_LOCATION_ID
40: INTO V_SHIP_TO_LOCATION_ID
41: FROM
42: PO_HEADERS_ALL
43: WHERE PO_HEADER_ID = V_PO_HEADER_ID;
44: SELECT
45: INVENTORY_ORGANIZATION_ID
46: INTO V_ORGANIZATION_ID
68: SELECT
69: LOCATION_CODE
70: FROM
71: HR_LOCATIONS HL,
72: PO_HEADERS_ALL PH,
73: PO_DISTRIBUTIONS_ALL POD
74: WHERE PH.PO_HEADER_ID = POD.PO_HEADER_ID
75: AND POD.PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID
76: AND HL.LOCATION_ID = PH.SHIP_TO_LOCATION_ID;