APPS.JA_JAINAPCR_XMLP_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 11: PO_DISTRIBUTIONS_ALL

7: SELECT
8: PO_HEADER_ID
9: INTO V_PO_HEADER_ID
10: FROM
11: PO_DISTRIBUTIONS_ALL
12: WHERE PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID;
13: SELECT
14: SEGMENT1
15: INTO V_PO_NUM

Line 36: PO_DISTRIBUTIONS_ALL

32: SELECT
33: PO_HEADER_ID
34: INTO V_PO_HEADER_ID
35: FROM
36: PO_DISTRIBUTIONS_ALL
37: WHERE PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID;
38: SELECT
39: SHIP_TO_LOCATION_ID
40: INTO V_SHIP_TO_LOCATION_ID

Line 73: PO_DISTRIBUTIONS_ALL POD

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;
77: BEGIN