APPS.WMS_WMSSCHS1_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 77: ORG_ORGANIZATION_DEFINITIONS

73: SELECT
74: OPERATING_UNIT
75: INTO L_MASTER_ORG_ID
76: FROM
77: ORG_ORGANIZATION_DEFINITIONS
78: WHERE ORGANIZATION_ID = P_ORG_ID;
79: FND_CLIENT_INFO.SET_ORG_CONTEXT(L_MASTER_ORG_ID);
80: IF P_SCHEDULE_SHIPMENT_FROM_DATE IS NOT NULL AND P_SCHEDULE_SHIPMENT_TO_DATE IS NOT NULL THEN
81: LP_SHIPMENT_SCHEDULE_DATE := ' AND to_char(OE1.SCHEDULE_SHIP_DATE,''YYYY/MM/DD'') BETWEEN ''' || SUBSTR(P_SCHEDULE_SHIPMENT_FROM_DATE

Line 143: ORG_ORGANIZATION_DEFINITIONS

139: ORGANIZATION_CODE,
140: ORGANIZATION_NAME
141: INTO P_ORG_CODE,P_ORG_NAME
142: FROM
143: ORG_ORGANIZATION_DEFINITIONS
144: WHERE ORGANIZATION_ID = P_ORG_ID;
145: END IF;
146: IF P_CUSTOMER_ID IS NOT NULL THEN
147: SELECT