DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 584: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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

Line 622: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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

Line 660: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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