APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 8: WSH_DELIVERY_DETAILS

4: CURSOR C_GET_NUM_DELIVERY_DETAILS(V_DELIVERY_DETAIL_ID IN NUMBER) IS
5: SELECT
6: SOURCE_HEADER_NUMBER
7: FROM
8: WSH_DELIVERY_DETAILS
9: WHERE CONTAINER_FLAG = 'N'
10: AND DELIVERY_DETAIL_ID = V_DELIVERY_DETAIL_ID;
11: CURSOR C_GET_DELIVERY_DETAILS(P_DELIVERY_DETAIL_ID IN NUMBER) IS
12: SELECT

Line 18: L_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;

14: FROM
15: WSH_DELIVERY_ASSIGNMENTS_V DA
16: START WITH DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
17: CONNECT BY prior DELIVERY_DETAIL_ID = PARENT_DELIVERY_DETAIL_ID;
18: L_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
19: L_FIRST_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
20: L_DELIVERY_DETAIL_ID NUMBER;
21: L_ORDER_COUNT NUMBER := 0;
22: L_COUNT NUMBER := 0;

Line 19: L_FIRST_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;

15: WSH_DELIVERY_ASSIGNMENTS_V DA
16: START WITH DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
17: CONNECT BY prior DELIVERY_DETAIL_ID = PARENT_DELIVERY_DETAIL_ID;
18: L_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
19: L_FIRST_ORDER_NUMBER WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
20: L_DELIVERY_DETAIL_ID NUMBER;
21: L_ORDER_COUNT NUMBER := 0;
22: L_COUNT NUMBER := 0;
23: BEGIN

Line 65: WSH_DELIVERY_DETAILS WDD

61: CURSOR C_GET_DELIVERY_DETAIL_ID(P_CONTAINER_NAME IN VARCHAR2) IS
62: SELECT
63: DELIVERY_DETAIL_ID
64: FROM
65: WSH_DELIVERY_DETAILS WDD
66: WHERE CONTAINER_NAME = P_CONTAINER_NAME
67: AND NVL(WDD.LINE_DIRECTION
68: ,'O') IN ( 'O' , 'IO' )
69: AND CONTAINER_FLAG = 'Y';

Line 314: WSH_DELIVERY_DETAILS

310: CURSOR C_IS_CONTAINER(P_DEL_DET_ID_1 IN NUMBER) IS
311: SELECT
312: 1
313: FROM
314: WSH_DELIVERY_DETAILS
315: WHERE DELIVERY_DETAIL_ID = P_DEL_DET_ID_1
316: AND CONTAINER_FLAG = 'Y';
317: CURSOR C_GET_DETAIL_HAVING_ST_CONTACT(P_DEL_DET_ID_2 IN NUMBER) IS
318: SELECT

Line 321: WSH_DELIVERY_DETAILS

317: CURSOR C_GET_DETAIL_HAVING_ST_CONTACT(P_DEL_DET_ID_2 IN NUMBER) IS
318: SELECT
319: DELIVERY_DETAIL_ID
320: FROM
321: WSH_DELIVERY_DETAILS
322: WHERE DELIVERY_DETAIL_ID in (
323: SELECT
324: WDA.DELIVERY_DETAIL_ID
325: FROM

Line 382: WSH_DELIVERY_DETAILS WDD

378: HZ_CUST_ACCOUNT_ROLES CAR
379: WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
380: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
381: AND CONT_POINT.CONTACT_POINT_TYPE not in ( 'EDI' , 'EMAIL' , 'WEB' ) ) PHONES,
382: WSH_DELIVERY_DETAILS WDD
383: WHERE WDD.DELIVERY_DETAIL_ID = P_DEL_DET_ID_3
384: AND WDD.SHIP_TO_CONTACT_ID = contact.cust_account_role_id (+)
385: AND CONTACT.CUST_ACCOUNT_ROLE_ID = phones.cust_account_role_id (+)
386: AND phones.phone_type (+) = 'PHONE' )