515: HR_LOCATIONS HRL,
516: RCV_TRANSACTIONS RCVT,
517: RCV_SHIPMENT_HEADERS RCVSH,
518: JAI_OM_WSH_LINES_ALL JSPL,
519: HR_ALL_ORGANIZATION_UNITS HRU
520: WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
521: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
522: AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
523: AND RCVSH.RECEIPT_SOURCE_CODE = LCV_INT_ORD
541: ,10) || ' ' || SUBSTR(HRL.COUNTRY
542: ,1
543: ,10)
544: FROM
545: HR_ALL_ORGANIZATION_UNITS HRU,
546: HR_LOCATIONS HRL
547: WHERE HRU.ORGANIZATION_ID = ABS(VENDOR_ID)
548: AND HRL.LOCATION_ID = ABS(VENDOR_SITE_ID)
549: AND HRU.LOCATION_ID = HRL.LOCATION_ID;