APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 285: L_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;

281: RETURN (TRUE);
282: END LP_WHERE_CLAUSEVALIDTRIGGER;
283:
284: FUNCTION CF_DOCK_CODEFORMULA(DELIVERY_ID3 IN NUMBER) RETURN CHAR IS
285: L_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
286: L_PREV_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
287: L_COUNT NUMBER;
288: CURSOR C_DOCK IS
289: SELECT

Line 286: L_PREV_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;

282: END LP_WHERE_CLAUSEVALIDTRIGGER;
283:
284: FUNCTION CF_DOCK_CODEFORMULA(DELIVERY_ID3 IN NUMBER) RETURN CHAR IS
285: L_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
286: L_PREV_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
287: L_COUNT NUMBER;
288: CURSOR C_DOCK IS
289: SELECT
290: DISTINCT

Line 293: WSH_DELIVERY_DETAILS WDD,

289: SELECT
290: DISTINCT
291: ( WDD.CUSTOMER_DOCK_CODE )
292: FROM
293: WSH_DELIVERY_DETAILS WDD,
294: WSH_DELIVERY_ASSIGNMENTS_V WDA
295: WHERE WDA.DELIVERY_ID = DELIVERY_ID3
296: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
297: AND NVL(WDD.CONTAINER_FLAG

Line 462: WSH_DELIVERY_DETAILS WDD

458: DISTINCT
459: INVENTORY_ITEM_ID,
460: ORGANIZATION_ID
461: FROM
462: WSH_DELIVERY_DETAILS WDD
463: WHERE WDD.DELIVERY_DETAIL_ID IN (
464: SELECT
465: WDA.DELIVERY_DETAIL_ID
466: FROM

Line 501: WSH_DELIVERY_DETAILS WDD,

497: WDD.SOURCE_HEADER_ID,
498: WDD.SOURCE_LINE_ID,
499: WDD.TOP_MODEL_LINE_ID
500: FROM
501: WSH_DELIVERY_DETAILS WDD,
502: WSH_DELIVERY_ASSIGNMENTS WDA
503: WHERE WDA.DELIVERY_ID = C_DELIVERY_ID
504: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
505: AND WDD.INVENTORY_ITEM_ID = C_INV_ITEM_ID