DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_TRIP_STOPS

Line 427: WSH_TRIP_STOPS WTS,

423: WT.TRIP_ID,
424: WT.NAME
425: FROM
426: WSH_TRIPS WT,
427: WSH_TRIP_STOPS WTS,
428: WSH_DELIVERY_LEGS WDL
429: WHERE WDL.DELIVERY_ID = DELIVERY_ID1
430: AND WTS.STOP_LOCATION_ID = INITIAL_PICKUP_LOCATION_ID
431: AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID

Line 555: WSH_TRIP_STOPS WTS,

551: ,NULL
552: ,''
553: ,', ') || LOC.COUNTRY
554: FROM
555: WSH_TRIP_STOPS WTS,
556: WSH_DELIVERY_LEGS WDL,
557: WSH_LOCATIONS LOC
558: WHERE WDL.DELIVERY_ID = P_DELIVERY_ID
559: AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID

Line 581: WSH_TRIP_STOPS WTS,

577: ,NULL
578: ,''
579: ,', ') || LOC.COUNTRY
580: FROM
581: WSH_TRIP_STOPS WTS,
582: WSH_DELIVERY_LEGS WDL,
583: WSH_DELIVERY_ASSIGNMENTS_V WDA,
584: WSH_DELIVERY_DETAILS WDD,
585: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

Line 619: WSH_TRIP_STOPS WTS,

615: ,NULL
616: ,''
617: ,', ') || LOC.COUNTRY
618: FROM
619: WSH_TRIP_STOPS WTS,
620: WSH_DELIVERY_LEGS WDL,
621: WSH_DELIVERY_ASSIGNMENTS_V WDA,
622: WSH_DELIVERY_DETAILS WDD,
623: MTL_MATERIAL_TRANSACTIONS MMT,

Line 657: WSH_TRIP_STOPS WTS,

653: ,NULL
654: ,''
655: ,', ') || LOC.COUNTRY
656: FROM
657: WSH_TRIP_STOPS WTS,
658: WSH_DELIVERY_LEGS WDL,
659: WSH_DELIVERY_ASSIGNMENTS_V WDA,
660: WSH_DELIVERY_DETAILS WDD,
661: MTL_TXN_REQUEST_LINES MTRL,