eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 550: WSH_DELIVERY_DETAILS WDD,

546: OEL.LINE_NUMBER SO_LINE_NUMBER,
547: WND.NAME DELIVERY_NAME
548: FROM
549: OE_ORDER_LINES_ALL OEL,
550: WSH_DELIVERY_DETAILS WDD,
551: WSH_DELIVERY_ASSIGNMENTS WDA,
552: WSH_NEW_DELIVERIES WND
553: WHERE WDD.MOVE_ORDER_LINE_ID = CF_SO_INFOFORMULA.LINE_ID
554: AND WDD.SOURCE_LINE_ID = OEL.LINE_ID