DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 583: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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,
586: WSH_LOCATIONS LOC
587: WHERE MMTT.PICK_SLIP_NUMBER = X_PS_NUMBER

Line 621: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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,
624: WSH_LOCATIONS LOC
625: WHERE MMT.PICK_SLIP_NUMBER = X_PS_NUMBER

Line 659: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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,
662: WSH_LOCATIONS LOC
663: WHERE MTRL.PICK_SLIP_NUMBER = X_PS_NUMBER