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: decode(P_STANDALONE ,'N', source_header_number,nvl(reference_number,source_header_number)) --STANDALONE CHANGES
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 321: WSH_DELIVERY_DETAILS

317: CURSOR C_IS_CONTAINER(P_DEL_DET_ID_1 IN NUMBER) IS
318: SELECT
319: 1
320: FROM
321: WSH_DELIVERY_DETAILS
322: WHERE DELIVERY_DETAIL_ID = P_DEL_DET_ID_1
323: AND CONTAINER_FLAG = 'Y';
324: CURSOR C_GET_DETAIL_HAVING_ST_CONTACT(P_DEL_DET_ID_2 IN NUMBER) IS
325: SELECT

Line 328: WSH_DELIVERY_DETAILS

324: CURSOR C_GET_DETAIL_HAVING_ST_CONTACT(P_DEL_DET_ID_2 IN NUMBER) IS
325: SELECT
326: DELIVERY_DETAIL_ID
327: FROM
328: WSH_DELIVERY_DETAILS
329: WHERE DELIVERY_DETAIL_ID in (
330: SELECT
331: WDA.DELIVERY_DETAIL_ID
332: FROM

Line 389: WSH_DELIVERY_DETAILS WDD

385: HZ_CUST_ACCOUNT_ROLES CAR
386: WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
387: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
388: AND CONT_POINT.CONTACT_POINT_TYPE not in ( 'EDI' , 'EMAIL' , 'WEB' ) ) PHONES,
389: WSH_DELIVERY_DETAILS WDD
390: WHERE WDD.DELIVERY_DETAIL_ID = P_DEL_DET_ID_3
391: AND WDD.SHIP_TO_CONTACT_ID = contact.cust_account_role_id (+)
392: AND CONTACT.CUST_ACCOUNT_ROLE_ID = phones.cust_account_role_id (+)
393: AND phones.phone_type (+) = 'PHONE' )