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 71: WSH_DELIVERY_ASSIGNMENTS_V WDA,

67: INTO L_SHIP_METHOD_CODE
68: FROM
69: WSH_TRIPS WT,
70: WSH_TRIP_STOPS WTS,
71: WSH_DELIVERY_ASSIGNMENTS_V WDA,
72: WSH_DELIVERY_LEGS WDL
73: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
74: AND WDA.DELIVERY_ID = C_Q2_DELIVERY_ID
75: AND WDA.DELIVERY_ID = WDL.DELIVERY_ID

Line 516: WSH_DELIVERY_ASSIGNMENTS_V WDA,

512: CURSOR BOXES IS
513: SELECT
514: count(*)
515: FROM
516: WSH_DELIVERY_ASSIGNMENTS_V WDA,
517: WSH_DELIVERY_DETAILS WDD
518: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
519: AND WDD.CONTAINER_FLAG = 'Y'
520: AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL

Line 587: WSH_DELIVERY_ASSIGNMENTS_V WDA,

583: OLA.INVOICE_TO_CONTACT_ID
584: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
585: FROM
586: WSH_DELIVERY_DETAILS WDD,
587: WSH_DELIVERY_ASSIGNMENTS_V WDA,
588: OE_ORDER_LINES_ALL OLA
589: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
590: AND NVL(WDD.CONTAINER_FLAG
591: ,'N') = 'N'

Line 610: WSH_DELIVERY_ASSIGNMENTS_V WDA,

606: WDD.SOURCE_LINE_ID
607: INTO OE_LINE_ID
608: FROM
609: WSH_DELIVERY_DETAILS WDD,
610: WSH_DELIVERY_ASSIGNMENTS_V WDA,
611: OE_ORDER_LINES_ALL OLA
612: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
613: AND WDD.CONTAINER_FLAG = 'N'
614: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 959: WSH_DELIVERY_ASSIGNMENTS_V WDA,

955: OLA.INVOICE_TO_CONTACT_ID
956: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
957: FROM
958: WSH_DELIVERY_DETAILS WDD,
959: WSH_DELIVERY_ASSIGNMENTS_V WDA,
960: OE_ORDER_LINES_ALL OLA
961: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
962: AND NVL(WDD.CONTAINER_FLAG
963: ,'N') = 'N'

Line 982: WSH_DELIVERY_ASSIGNMENTS_V WDA

978: WDD.SOURCE_LINE_ID
979: INTO OE_LINE_ID
980: FROM
981: WSH_DELIVERY_DETAILS WDD,
982: WSH_DELIVERY_ASSIGNMENTS_V WDA
983: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
984: AND WDD.CONTAINER_FLAG = 'N'
985: AND WDA.DELIVERY_ID = P_DELIVERY_ID
986: AND WDA.DELIVERY_ID is not null

Line 1015: WSH_DELIVERY_ASSIGNMENTS_V WDA

1011: count(distinct WDD.SOURCE_CODE)
1012: INTO L_COUNT
1013: FROM
1014: WSH_DELIVERY_DETAILS WDD,
1015: WSH_DELIVERY_ASSIGNMENTS_V WDA
1016: WHERE WDA.DELIVERY_ID IS NOT NULL
1017: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
1018: AND WDA.DELIVERY_ID = P_DELIVERY_ID
1019: AND WDD.CONTAINER_FLAG = 'N'

Line 1031: WSH_DELIVERY_ASSIGNMENTS_V WDA

1027: WDD.DELIVERY_DETAIL_ID
1028: INTO L_SOURCE_CODE,DEL_DTL_ID
1029: FROM
1030: WSH_DELIVERY_DETAILS WDD,
1031: WSH_DELIVERY_ASSIGNMENTS_V WDA
1032: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1033: AND WDD.CONTAINER_FLAG = 'N'
1034: AND WDA.DELIVERY_ID = P_DELIVERY_ID
1035: AND WDA.DELIVERY_ID is not null