APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 293: WSH_DELIVERY_DETAILS WDD,

289: SUM(WDD.REQUESTED_QUANTITY) - NVL(SUM(WDD.SHIPPED_QUANTITY)
290: ,0)
291: INTO TOTAL_UNSHIPPED_QUANTITY
292: FROM
293: WSH_DELIVERY_DETAILS WDD,
294: OE_ORDER_LINES_ALL L
295: WHERE WDD.SOURCE_LINE_ID = L.LINE_ID
296: AND WDD.SOURCE_CODE = 'OE'
297: AND WDD.CONTAINER_FLAG = 'N'

Line 307: WSH_DELIVERY_DETAILS WDD

303: SUM(WDD.REQUESTED_QUANTITY) - NVL(SUM(WDD.SHIPPED_QUANTITY)
304: ,0)
305: INTO TOTAL_UNSHIPPED_QUANTITY
306: FROM
307: WSH_DELIVERY_DETAILS WDD
308: WHERE WDD.SOURCE_LINE_ID = C_SRC_LINE_ID
309: AND WDD.SOURCE_CODE = 'OKE';
310: END IF;
311: RETURN TOTAL_UNSHIPPED_QUANTITY;

Line 517: WSH_DELIVERY_DETAILS WDD

513: SELECT
514: count(*)
515: FROM
516: WSH_DELIVERY_ASSIGNMENTS_V WDA,
517: WSH_DELIVERY_DETAILS WDD
518: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
519: AND WDD.CONTAINER_FLAG = 'Y'
520: AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL
521: AND WDA.DELIVERY_ID is not null

Line 586: WSH_DELIVERY_DETAILS WDD,

582: OLA.SHIP_TO_CONTACT_ID,
583: OLA.INVOICE_TO_CONTACT_ID
584: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
585: FROM
586: WSH_DELIVERY_DETAILS WDD,
587: WSH_DELIVERY_ASSIGNMENTS_V WDA,
588: OE_ORDER_LINES_ALL OLA
589: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
590: AND NVL(WDD.CONTAINER_FLAG

Line 609: WSH_DELIVERY_DETAILS WDD,

605: SELECT
606: WDD.SOURCE_LINE_ID
607: INTO OE_LINE_ID
608: FROM
609: WSH_DELIVERY_DETAILS WDD,
610: WSH_DELIVERY_ASSIGNMENTS_V WDA,
611: OE_ORDER_LINES_ALL OLA
612: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
613: AND WDD.CONTAINER_FLAG = 'N'

Line 885: WSH_DELIVERY_DETAILS

881: SELECT
882: SHIP_TO_SITE_USE_ID
883: INTO SHP_TO_SITE_USE_ID
884: FROM
885: WSH_DELIVERY_DETAILS
886: WHERE DELIVERY_DETAIL_ID = F_DEL_DETAIL_ID
887: AND SOURCE_CODE = 'OE'
888: AND ROWNUM < 2;
889: IF SQL%NOTFOUND THEN

Line 897: WSH_DELIVERY_DETAILS

893: SELECT
894: SHIP_TO_SITE_USE_ID
895: INTO SHP_TO_SITE_USE_ID
896: FROM
897: WSH_DELIVERY_DETAILS
898: WHERE DELIVERY_DETAIL_ID = F_DEL_DETAIL_ID
899: AND SOURCE_CODE = 'OKE'
900: AND ROWNUM < 2;
901: END IF;

Line 958: WSH_DELIVERY_DETAILS WDD,

954: OLA.SHIP_TO_CONTACT_ID,
955: OLA.INVOICE_TO_CONTACT_ID
956: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
957: FROM
958: WSH_DELIVERY_DETAILS WDD,
959: WSH_DELIVERY_ASSIGNMENTS_V WDA,
960: OE_ORDER_LINES_ALL OLA
961: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
962: AND NVL(WDD.CONTAINER_FLAG

Line 981: WSH_DELIVERY_DETAILS WDD,

977: SELECT
978: WDD.SOURCE_LINE_ID
979: INTO OE_LINE_ID
980: FROM
981: WSH_DELIVERY_DETAILS WDD,
982: WSH_DELIVERY_ASSIGNMENTS_V WDA
983: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
984: AND WDD.CONTAINER_FLAG = 'N'
985: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 1014: WSH_DELIVERY_DETAILS WDD,

1010: SELECT
1011: count(distinct WDD.SOURCE_CODE)
1012: INTO L_COUNT
1013: FROM
1014: WSH_DELIVERY_DETAILS WDD,
1015: WSH_DELIVERY_ASSIGNMENTS_V WDA
1016: WHERE WDA.DELIVERY_ID IS NOT NULL
1017: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
1018: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 1030: WSH_DELIVERY_DETAILS WDD,

1026: WDD.SOURCE_CODE,
1027: WDD.DELIVERY_DETAIL_ID
1028: INTO L_SOURCE_CODE,DEL_DTL_ID
1029: FROM
1030: WSH_DELIVERY_DETAILS WDD,
1031: WSH_DELIVERY_ASSIGNMENTS_V WDA
1032: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1033: AND WDD.CONTAINER_FLAG = 'N'
1034: AND WDA.DELIVERY_ID = P_DELIVERY_ID