APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 274: L_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;

270: RETURN (TRUE);
271: END LP_WHERE_CLAUSEVALIDTRIGGER;
272:
273: FUNCTION CF_DOCK_CODEFORMULA(DELIVERY_ID3 IN NUMBER) RETURN CHAR IS
274: L_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
275: L_PREV_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
276: L_COUNT NUMBER;
277: CURSOR C_DOCK IS
278: SELECT

Line 275: L_PREV_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;

271: END LP_WHERE_CLAUSEVALIDTRIGGER;
272:
273: FUNCTION CF_DOCK_CODEFORMULA(DELIVERY_ID3 IN NUMBER) RETURN CHAR IS
274: L_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
275: L_PREV_DOCK_CODE WSH_DELIVERY_DETAILS.CUSTOMER_DOCK_CODE%TYPE;
276: L_COUNT NUMBER;
277: CURSOR C_DOCK IS
278: SELECT
279: DISTINCT

Line 282: WSH_DELIVERY_DETAILS WDD,

278: SELECT
279: DISTINCT
280: ( WDD.CUSTOMER_DOCK_CODE )
281: FROM
282: WSH_DELIVERY_DETAILS WDD,
283: WSH_DELIVERY_ASSIGNMENTS_V WDA
284: WHERE WDA.DELIVERY_ID = DELIVERY_ID3
285: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
286: AND NVL(WDD.CONTAINER_FLAG

Line 451: WSH_DELIVERY_DETAILS WDD

447: DISTINCT
448: INVENTORY_ITEM_ID,
449: ORGANIZATION_ID
450: FROM
451: WSH_DELIVERY_DETAILS WDD
452: WHERE WDD.DELIVERY_DETAIL_ID IN (
453: SELECT
454: WDA.DELIVERY_DETAIL_ID
455: FROM

Line 490: WSH_DELIVERY_DETAILS WDD,

486: WDD.SOURCE_HEADER_ID,
487: WDD.SOURCE_LINE_ID,
488: WDD.TOP_MODEL_LINE_ID
489: FROM
490: WSH_DELIVERY_DETAILS WDD,
491: WSH_DELIVERY_ASSIGNMENTS WDA
492: WHERE WDA.DELIVERY_ID = C_DELIVERY_ID
493: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
494: AND WDD.INVENTORY_ITEM_ID = C_INV_ITEM_ID