DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_TRIP_STOPS

Line 428: WSH_TRIP_STOPS WTS,

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

Line 556: WSH_TRIP_STOPS WTS,

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

Line 582: WSH_TRIP_STOPS WTS,

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

Line 620: WSH_TRIP_STOPS WTS,

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

Line 658: WSH_TRIP_STOPS WTS,

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