DBA Data[Home] [Help]

APPS.INV_INVTOPKL_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 179: P_FROM_MMT := P_FROM_MMT || ', WSH_DELIVERY_DETAILS WDD';

175: P_WHERE_MMT := P_WHERE_MMT || ' AND MMT.PICK_SLIP_NUMBER <= :P_PICK_SLIP_NUMBER_HIGH';
176: P_WHERE_MMTT := P_WHERE_MMTT || ' AND MMTT.PICK_SLIP_NUMBER <= :P_PICK_SLIP_NUMBER_HIGH';
177: END IF;
178: IF P_SALES_ORDER_LOW IS NOT NULL OR P_SALES_ORDER_HIGH IS NOT NULL OR P_CUSTOMER_ID IS NOT NULL OR P_FREIGHT_CODE IS NOT NULL THEN
179: P_FROM_MMT := P_FROM_MMT || ', WSH_DELIVERY_DETAILS WDD';
180: P_FROM_MMTT := P_FROM_MMTT || ', WSH_DELIVERY_DETAILS WDD';
181: P_FROM_MTRL := P_FROM_MTRL || ', WSH_DELIVERY_DETAILS WDD';
182: L_TEMP_WHERE := '';
183: IF P_SALES_ORDER_LOW IS NOT NULL THEN

Line 180: P_FROM_MMTT := P_FROM_MMTT || ', WSH_DELIVERY_DETAILS WDD';

176: P_WHERE_MMTT := P_WHERE_MMTT || ' AND MMTT.PICK_SLIP_NUMBER <= :P_PICK_SLIP_NUMBER_HIGH';
177: END IF;
178: IF P_SALES_ORDER_LOW IS NOT NULL OR P_SALES_ORDER_HIGH IS NOT NULL OR P_CUSTOMER_ID IS NOT NULL OR P_FREIGHT_CODE IS NOT NULL THEN
179: P_FROM_MMT := P_FROM_MMT || ', WSH_DELIVERY_DETAILS WDD';
180: P_FROM_MMTT := P_FROM_MMTT || ', WSH_DELIVERY_DETAILS WDD';
181: P_FROM_MTRL := P_FROM_MTRL || ', WSH_DELIVERY_DETAILS WDD';
182: L_TEMP_WHERE := '';
183: IF P_SALES_ORDER_LOW IS NOT NULL THEN
184: L_TEMP_WHERE := L_TEMP_WHERE || ' AND WDD.SOURCE_HEADER_NUMBER >= :P_SALES_ORDER_LOW ';

Line 181: P_FROM_MTRL := P_FROM_MTRL || ', WSH_DELIVERY_DETAILS WDD';

177: END IF;
178: IF P_SALES_ORDER_LOW IS NOT NULL OR P_SALES_ORDER_HIGH IS NOT NULL OR P_CUSTOMER_ID IS NOT NULL OR P_FREIGHT_CODE IS NOT NULL THEN
179: P_FROM_MMT := P_FROM_MMT || ', WSH_DELIVERY_DETAILS WDD';
180: P_FROM_MMTT := P_FROM_MMTT || ', WSH_DELIVERY_DETAILS WDD';
181: P_FROM_MTRL := P_FROM_MTRL || ', WSH_DELIVERY_DETAILS WDD';
182: L_TEMP_WHERE := '';
183: IF P_SALES_ORDER_LOW IS NOT NULL THEN
184: L_TEMP_WHERE := L_TEMP_WHERE || ' AND WDD.SOURCE_HEADER_NUMBER >= :P_SALES_ORDER_LOW ';
185: END IF;

Line 559: WSH_DELIVERY_DETAILS WDD,

555: OEL.LINE_NUMBER SO_LINE_NUMBER,
556: WND.NAME DELIVERY_NAME
557: FROM
558: OE_ORDER_LINES_ALL OEL,
559: WSH_DELIVERY_DETAILS WDD,
560: WSH_DELIVERY_ASSIGNMENTS WDA,
561: WSH_NEW_DELIVERIES WND
562: WHERE WDD.MOVE_ORDER_LINE_ID = CF_SO_INFOFORMULA.LINE_ID
563: AND WDD.SOURCE_LINE_ID = OEL.LINE_ID