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.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 86: WSH_DELIVERY_ASSIGNMENTS_V WDA,

82: INTO L_SHIP_METHOD_CODE
83: FROM
84: WSH_TRIPS WT,
85: WSH_TRIP_STOPS WTS,
86: WSH_DELIVERY_ASSIGNMENTS_V WDA,
87: WSH_DELIVERY_LEGS WDL
88: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
89: AND WDA.DELIVERY_ID = C_Q2_DELIVERY_ID
90: AND WDA.DELIVERY_ID = WDL.DELIVERY_ID

Line 539: WSH_DELIVERY_ASSIGNMENTS_V WDA,

535: CURSOR BOXES IS
536: SELECT
537: count(*)
538: FROM
539: WSH_DELIVERY_ASSIGNMENTS_V WDA,
540: WSH_DELIVERY_DETAILS WDD
541: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
542: AND WDD.CONTAINER_FLAG = 'Y'
543: AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL

Line 667: WSH_DELIVERY_ASSIGNMENTS_V WDA,

663: OLA.INVOICE_TO_CONTACT_ID
664: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
665: FROM
666: WSH_DELIVERY_DETAILS WDD,
667: WSH_DELIVERY_ASSIGNMENTS_V WDA,
668: OE_ORDER_LINES_ALL OLA
669: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
670: AND NVL(WDD.CONTAINER_FLAG
671: ,'N') = 'N'

Line 690: WSH_DELIVERY_ASSIGNMENTS_V WDA,

686: WDD.SOURCE_LINE_ID
687: INTO OE_LINE_ID
688: FROM
689: WSH_DELIVERY_DETAILS WDD,
690: WSH_DELIVERY_ASSIGNMENTS_V WDA,
691: OE_ORDER_LINES_ALL OLA
692: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
693: AND WDD.CONTAINER_FLAG = 'N'
694: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 1160: WSH_DELIVERY_ASSIGNMENTS_V WDA,

1156: OLA.INVOICE_TO_CONTACT_ID
1157: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
1158: FROM
1159: WSH_DELIVERY_DETAILS WDD,
1160: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1161: OE_ORDER_LINES_ALL OLA
1162: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1163: AND NVL(WDD.CONTAINER_FLAG
1164: ,'N') = 'N'

Line 1183: WSH_DELIVERY_ASSIGNMENTS_V WDA

1179: WDD.SOURCE_LINE_ID
1180: INTO OE_LINE_ID
1181: FROM
1182: WSH_DELIVERY_DETAILS WDD,
1183: WSH_DELIVERY_ASSIGNMENTS_V WDA
1184: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1185: AND WDD.CONTAINER_FLAG = 'N'
1186: AND WDA.DELIVERY_ID = P_DELIVERY_ID
1187: AND WDA.DELIVERY_ID is not null

Line 1198: WSH_DELIVERY_ASSIGNMENTS_V WDA

1194: SELECT SOURCE_LINE_ID
1195: INTO OE_LINE_ID
1196: FROM
1197: WSH_DELIVERY_DETAILS WDD,
1198: WSH_DELIVERY_ASSIGNMENTS_V WDA
1199: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1200: AND WDD.CONTAINER_FLAG = 'N'
1201: AND WDA.DELIVERY_ID = P_DELIVERY_ID
1202: AND WDA.DELIVERY_ID is not null

Line 1231: WSH_DELIVERY_ASSIGNMENTS_V WDA

1227: count(distinct WDD.SOURCE_CODE)
1228: INTO L_COUNT
1229: FROM
1230: WSH_DELIVERY_DETAILS WDD,
1231: WSH_DELIVERY_ASSIGNMENTS_V WDA
1232: WHERE WDA.DELIVERY_ID IS NOT NULL
1233: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
1234: AND WDA.DELIVERY_ID = P_DELIVERY_ID
1235: AND WDD.CONTAINER_FLAG = 'N'

Line 1247: WSH_DELIVERY_ASSIGNMENTS_V WDA

1243: WDD.DELIVERY_DETAIL_ID
1244: INTO L_SOURCE_CODE,DEL_DTL_ID
1245: FROM
1246: WSH_DELIVERY_DETAILS WDD,
1247: WSH_DELIVERY_ASSIGNMENTS_V WDA
1248: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1249: AND WDD.CONTAINER_FLAG = 'N'
1250: AND WDA.DELIVERY_ID = P_DELIVERY_ID
1251: AND WDA.DELIVERY_ID is not null