eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: HR_LOCATIONS_ALL

Product:	PER - Human Resources
Description:	Work location definitions.
Implementation/DBA Data:	HR.HR_LOCATIONS_ALL

Primary Key: HR_LOCATIONS_PK

LOCATION_ID

Primary Key: HR_LOCATIONS_UK2

LOCATION_CODE
BUSINESS_GROUP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_REPORTING_ENTITIES_ALL	HR_LOCATIONS_ALL	AP_REPORTING_ENTITIES_ALL.LOCATION_ID
AP_SYSTEM_PARAMETERS_ALL	HR_LOCATIONS_ALL	AP_SYSTEM_PARAMETERS_ALL.LOCATION_ID
AR_TAX_EXTRACT_DCL_ITF	HR_LOCATIONS_ALL	AR_TAX_EXTRACT_DCL_ITF.LEGAL_ENTITY_LOCATION_ID
BOM_DEPARTMENTS	HR_LOCATIONS_ALL	BOM_DEPARTMENTS.LOCATION_ID
CSI_A_LOCATIONS	HR_LOCATIONS_ALL	CSI_A_LOCATIONS.LOCATION_ID
CSI_A_LOCATIONS	HR_LOCATIONS_ALL	CSI_A_LOCATIONS.LOCATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL	HR_LOCATIONS_ALL	FINANCIALS_SYSTEM_PARAMS_ALL.BILL_TO_LOCATION_ID
FINANCIALS_SYSTEM_PARAMS_ALL	HR_LOCATIONS_ALL	FINANCIALS_SYSTEM_PARAMS_ALL.SHIP_TO_LOCATION_ID
HR_ALL_POSITIONS_F	HR_LOCATIONS_ALL	HR_ALL_POSITIONS_F.LOCATION_ID
HR_LOCATION_EXTRA_INFO	HR_LOCATIONS_ALL	HR_LOCATION_EXTRA_INFO.LOCATION_ID
HR_ALL_ORGANIZATION_UNITS	HR_LOCATIONS_ALL	HR_ALL_ORGANIZATION_UNITS.LOCATION_ID
ICX_SHOPPING_CARTS	HR_LOCATIONS_ALL	ICX_SHOPPING_CARTS.DELIVER_TO_LOCATION_ID
ICX_SHOPPING_CART_LINES	HR_LOCATIONS_ALL	ICX_SHOPPING_CART_LINES.DELIVER_TO_LOCATION_ID
IGC_CC_HEADERS	HR_LOCATIONS_ALL	IGC_CC_HEADERS.LOCATION_ID
JAI_AP_INVOICE_LINES	HR_LOCATIONS_ALL	JAI_AP_INVOICE_LINES.LOCATION_ID
JAI_AR_TRXS	HR_LOCATIONS_ALL	JAI_AR_TRXS.LOCATION_ID
JAI_AR_TRX_INS_HDRS_T	HR_LOCATIONS_ALL	JAI_AR_TRX_INS_HDRS_T.LOCATION_ID
JAI_CMN_BOE_HDRS	HR_LOCATIONS_ALL	JAI_CMN_BOE_HDRS.LOCATION_ID
JAI_CMN_INVENTORY_ORGS	HR_LOCATIONS_ALL	JAI_CMN_INVENTORY_ORGS.LOCATION_ID
JAI_CMN_OM_AR_AR3_FORMS	HR_LOCATIONS_ALL	JAI_CMN_OM_AR_AR3_FORMS.LOCATION_ID
JAI_CMN_RG_23AC_II_TRXS	HR_LOCATIONS_ALL	JAI_CMN_RG_23AC_II_TRXS.LOCATION_ID
JAI_CMN_RG_23AC_I_TRXS	HR_LOCATIONS_ALL	JAI_CMN_RG_23AC_I_TRXS.LOCATION_ID
JAI_CMN_RG_23D_TRXS	HR_LOCATIONS_ALL	JAI_CMN_RG_23D_TRXS.LOCATION_ID
JAI_CMN_RG_BALANCES	HR_LOCATIONS_ALL	JAI_CMN_RG_BALANCES.LOCATION_ID
JAI_CMN_RG_COMP_BALS	HR_LOCATIONS_ALL	JAI_CMN_RG_COMP_BALS.LOCATION_ID
JAI_CMN_RG_COMP_DTLS	HR_LOCATIONS_ALL	JAI_CMN_RG_COMP_DTLS.LOCATION_ID
JAI_CMN_RG_CONSLDATIONS	HR_LOCATIONS_ALL	JAI_CMN_RG_CONSLDATIONS.LOCATION_ID
JAI_CMN_RG_EXC_INV_NOS	HR_LOCATIONS_ALL	JAI_CMN_RG_EXC_INV_NOS.LOCATION_ID
JAI_CMN_RG_I_TRXS	HR_LOCATIONS_ALL	JAI_CMN_RG_I_TRXS.LOCATION_ID
JAI_CMN_RG_PERIOD_BALS	HR_LOCATIONS_ALL	JAI_CMN_RG_PERIOD_BALS.LOCATION_ID
JAI_CMN_RG_PLA_CMP_DTLS	HR_LOCATIONS_ALL	JAI_CMN_RG_PLA_CMP_DTLS.LOCATION_ID
JAI_CMN_RG_PLA_HDRS	HR_LOCATIONS_ALL	JAI_CMN_RG_PLA_HDRS.LOCATION_ID
JAI_CMN_RG_PLA_TRXS	HR_LOCATIONS_ALL	JAI_CMN_RG_PLA_TRXS.LOCATION_ID
JAI_CMN_RG_TRANSFERS	HR_LOCATIONS_ALL	JAI_CMN_RG_TRANSFERS.FROM_LOCATION_ID
JAI_CMN_RG_TRANSFERS	HR_LOCATIONS_ALL	JAI_CMN_RG_TRANSFERS.TO_LOCATION_ID
JAI_CMN_ST_FORM_DTLS	HR_LOCATIONS_ALL	JAI_CMN_ST_FORM_DTLS.LOCATION_ID
JAI_INV_SUBINV_DTLS	HR_LOCATIONS_ALL	JAI_INV_SUBINV_DTLS.LOCATION_ID
JAI_INV_SUBINV_HDRS	HR_LOCATIONS_ALL	JAI_INV_SUBINV_HDRS.LOCATION_ID
JAI_PO_OSP_CENVAT_HDRS	HR_LOCATIONS_ALL	JAI_PO_OSP_CENVAT_HDRS.LOCATION_ID
JAI_PO_OSP_FORM_NUMBERS	HR_LOCATIONS_ALL	JAI_PO_OSP_FORM_NUMBERS.LOCATION_ID
JAI_PO_OSP_HDRS	HR_LOCATIONS_ALL	JAI_PO_OSP_HDRS.LOCATION_ID
JAI_PO_RMA_RTN_LINES	HR_LOCATIONS_ALL	JAI_PO_RMA_RTN_LINES.LOCATION_ID
JAI_RCV_RGM_LINES	HR_LOCATIONS_ALL	JAI_RCV_RGM_LINES.LOCATION_ID
JAI_RCV_RTV_BATCH_GRPS	HR_LOCATIONS_ALL	JAI_RCV_RTV_BATCH_GRPS.LOCATION_ID
JAI_RCV_TRANSACTIONS	HR_LOCATIONS_ALL	JAI_RCV_TRANSACTIONS.LOCATION_ID
JAI_RGM_BALANCE_T	HR_LOCATIONS_ALL	JAI_RGM_BALANCE_T.LOCATION_ID
JAI_RGM_DIS_DES_HDRS	HR_LOCATIONS_ALL	JAI_RGM_DIS_DES_HDRS.LOCATION_ID
JAI_RGM_DIS_SRC_HDRS	HR_LOCATIONS_ALL	JAI_RGM_DIS_SRC_HDRS.LOCATION_ID
JAI_RGM_DOC_SEQ_HDRS	HR_LOCATIONS_ALL	JAI_RGM_DOC_SEQ_HDRS.PARTY_SITE_ID
JAI_RGM_INVOICE_GEN_T	HR_LOCATIONS_ALL	JAI_RGM_INVOICE_GEN_T.LOCATION_ID
JAI_RGM_PARTIES	HR_LOCATIONS_ALL	JAI_RGM_PARTIES.LOCATION_ID
JAI_RGM_STL_BALANCES	HR_LOCATIONS_ALL	JAI_RGM_STL_BALANCES.LOCATION_ID
JAI_RGM_TERM_ASSIGNS	HR_LOCATIONS_ALL	JAI_RGM_TERM_ASSIGNS.LOCATION_ID
JAI_RGM_TRX_RECORDS	HR_LOCATIONS_ALL	JAI_RGM_TRX_RECORDS.LOCATION_ID
JA_AU_SUBINV_LOC_ASSOCS	HR_LOCATIONS_ALL	JA_AU_SUBINV_LOC_ASSOCS.LOCATION_ID
JG_ZZ_VAT_UPG_STG	HR_LOCATIONS_ALL	JG_ZZ_VAT_UPG_STG.LOCATION_ID
MRP_WORKBENCH_QUERY	HR_LOCATIONS_ALL	MRP_WORKBENCH_QUERY.LOCATION_ID
MTL_INTERORG_SHIP_METHODS	HR_LOCATIONS_ALL	MTL_INTERORG_SHIP_METHODS.FROM_LOCATION_ID
MTL_INTERORG_SHIP_METHODS	HR_LOCATIONS_ALL	MTL_INTERORG_SHIP_METHODS.TO_LOCATION_ID
MTL_REPLENISH_HEADERS	HR_LOCATIONS_ALL	MTL_REPLENISH_HEADERS.DELIVERY_LOCATION_ID
IGC_CC_ARC_HEADERS	HR_LOCATIONS_ALL	IGC_CC_ARC_HEADERS.LOCATION_ID
IGC_CC_HEADERS_INTERFACE	HR_LOCATIONS_ALL	IGC_CC_HEADERS_INTERFACE.LOCATION_ID
PAY_ELEMENT_LINKS_F	HR_LOCATIONS_ALL	PAY_ELEMENT_LINKS_F.LOCATION_ID
PAY_WCI_ACCOUNTS	HR_LOCATIONS_ALL	PAY_WCI_ACCOUNTS.LOCATION_ID
PAY_WC_FUNDS	HR_LOCATIONS_ALL	PAY_WC_FUNDS.LOCATION_ID
PER_ALL_ASSIGNMENTS_F	HR_LOCATIONS_ALL	PER_ALL_ASSIGNMENTS_F.LOCATION_ID
PER_EVENTS	HR_LOCATIONS_ALL	PER_EVENTS.LOCATION_ID
PER_ALL_POSITIONS	HR_LOCATIONS_ALL	PER_ALL_POSITIONS.LOCATION_ID
PER_SALARY_SURVEY_MAPPINGS	HR_LOCATIONS_ALL	PER_SALARY_SURVEY_MAPPINGS.LOCATION_ID
PER_ALL_VACANCIES	HR_LOCATIONS_ALL	PER_ALL_VACANCIES.LOCATION_ID
PON_AUCTION_HEADERS_ALL	HR_LOCATIONS_ALL	PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID
PON_AUCTION_HEADERS_ALL	HR_LOCATIONS_ALL	PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID
PON_AUCTION_SHIPMENTS_ALL	HR_LOCATIONS_ALL	PON_AUCTION_SHIPMENTS_ALL.SHIP_TO_LOCATION_ID
PON_AUC_HEADERS_INTERFACE	HR_LOCATIONS_ALL	PON_AUC_HEADERS_INTERFACE.SHIP_TO_LOCATION_ID
PON_AUC_HEADERS_INTERFACE	HR_LOCATIONS_ALL	PON_AUC_HEADERS_INTERFACE.BILL_TO_LOCATION_ID
PON_AUC_PAYMENTS_SHIPMENTS	HR_LOCATIONS_ALL	PON_AUC_PAYMENTS_SHIPMENTS.SHIP_TO_LOCATION_ID
PON_AUC_SHIPMENTS_INTERFACE	HR_LOCATIONS_ALL	PON_AUC_SHIPMENTS_INTERFACE.SHIP_TO_LOCATION_ID
PON_BID_SHIPMENTS	HR_LOCATIONS_ALL	PON_BID_SHIPMENTS.SHIP_TO_LOCATION_ID
PO_HEADERS_ALL	HR_LOCATIONS_ALL	PO_HEADERS_ALL.SHIP_TO_LOCATION_ID
PO_HEADERS_ALL	HR_LOCATIONS_ALL	PO_HEADERS_ALL.BILL_TO_LOCATION_ID
PO_LINE_LOCATIONS_ALL	HR_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID
PQH_POSITION_TRANSACTIONS	HR_LOCATIONS_ALL	PQH_POSITION_TRANSACTIONS.LOCATION_ID
RCV_TRANSACTIONS	HR_LOCATIONS_ALL	RCV_TRANSACTIONS.LOCATION_ID
WSH_DOC_SEQUENCE_CATEGORIES	HR_LOCATIONS_ALL	WSH_DOC_SEQUENCE_CATEGORIES.LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.POA_LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.POO_LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS	HR_LOCATIONS_ALL	ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID
ZX_LINES	HR_LOCATIONS_ALL	ZX_LINES.INTERNAL_ORG_LOCATION_ID