DBA Data[Home] [Help]

APPS.JA_JAIN23C1_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 519: HR_ALL_ORGANIZATION_UNITS HRU

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

Line 545: HR_ALL_ORGANIZATION_UNITS HRU,

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;