[Home] [Help]
[Dependency Information]
| Object Name: | HR_OPERATING_UNITS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PER.HR_OPERATING_UNITS
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
HR_OPERATING_UNITS is a view based on HR_ORGANIZATION_UNITS and
HR_ORGANIZATION_INFORMATION that returns information about operating
units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Refer to base table. |
| ORGANIZATION_ID | NUMBER | (15) | Yes | Refer to base table. |
| NAME | VARCHAR2 | (240) | Yes | Refer to base table. |
| DATE_FROM | DATE | Yes | Refer to base table. | |
| DATE_TO | DATE | Refer to base table. | ||
| SHORT_CODE | VARCHAR2 | (150) | Refer to base table. | |
| SET_OF_BOOKS_ID | VARCHAR2 | (150) | Refer to base table. | |
| DEFAULT_LEGAL_CONTEXT_ID | VARCHAR2 | (150) | Refer to base table. | |
| USABLE_FLAG | VARCHAR2 | (150) | Useable Flag (Y/N) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_ID
, ORGANIZATION_ID
, NAME
, DATE_FROM
, DATE_TO
, SHORT_CODE
, SET_OF_BOOKS_ID
, DEFAULT_LEGAL_CONTEXT_ID
, USABLE_FLAG
FROM APPS.HR_OPERATING_UNITS;
APPS
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_ORGANIZATION_INFORMATION
APPS
AD_MORG
- show dependent code
AHL_APPROVALS_PVT
- show dependent code
ALR_ALERT_INSTALLATIONS_PKG
- show dependent code
AMS_ACCT_INTEREST_V
AMS_USER_ORG_V
AP_APXCCPUT_XMLP_PKG
- show dependent code
AP_APXTRSWP_XMLP_PKG
- show dependent code
AP_IMPORT_INVOICES_PKG
- show dependent code
AP_IMPORT_INVOICES_PKG
- show dependent code
AP_OPEN_BAL_REV_RPT_PKG
- show dependent code
AP_PERIOD_CLOSE_PKG
- show dependent code
AP_UTILITIES_PKG
- show dependent code
AP_VENDOR_PUB_PKG
- show dependent code
AP_VENDOR_PUB_PKG
- show dependent code
ARI_SELF_REG_CONFIG
- show dependent code
ARP_CMERGE_MASTER
- show dependent code
ARP_LEGAL_ENTITY_UTIL
- show dependent code
AR_AI_ORG_V
AR_CONS_INV_V
AR_OBALREV_PKG
- show dependent code
AR_SYSTEM_PARAMETERS_OU_V
ASO_I_ORDER_HEADERS_BALI_V
ASO_I_QUOTE_HEADERS_BALI_V
ASO_PVT_CUST_ORDER_HDRS_BALI_V
ASO_PVT_CUST_QUOTE_HDRS_BALI_V
AST_LM_QUOTES_V
AST_OPPORTUNITY_LINES_V
AST_ORDER_HEADERS_V
AS_ACCESS_PVT
- show dependent code
AS_OPP_HEADER_PVT
- show dependent code
AZW_PROC
- show dependent code
AZW_UTIL
- show dependent code
BIC_DIMV_OPERATING_UNITS
BIS_MONTHS_V
BIS_QUARTERS_V
BIS_YEARS_V
BOM_CSTROMMA_XMLP_PKG
- show dependent code
CEP_STANDARD
- show dependent code
CE_CSH_FCST_POP
- show dependent code
CE_FC_API_DISC_V
CE_FC_APP_DISC_V
CE_FC_APX_DISC_V
CE_FC_ARI_DISC_V
CE_FC_ARR_DISC_V
CE_FC_ASF_DISC_V
CE_FC_OEO_DISC_V
CE_FC_PAB_DISC_V
CE_FC_PAIO_DISC_V
CE_FC_PAT_DISC_V
CE_FC_POP_DISC_V
CE_FC_POR_DISC_V
CE_FORECAST_AP_ORGS_V
CE_FORECAST_AR_ORGS_V
CE_FORECAST_AS_ORGS_V
CE_FORECAST_OE_ORGS_V
CE_FORECAST_PA_ORGS_V
CE_FORECAST_PO_ORGS_V
CE_FORECAST_ROWS_V
CE_LE_BG_OU_VS_V
CE_SECURITY_PROFILES_V
CN_GET_COMM_PMT_PAID_GRP
- show dependent code
CN_PAYRUN_PVT
- show dependent code
CN_PAYRUN_PVT
- show dependent code
CSC_ACCT_SITE_USES_V
CSC_CUST_ACCT_SITES_V
CSD_COST_ANALYSIS_UTIL
- show dependent code
CSD_MIGRATE_FROM_115X_PKG3
- show dependent code
CSD_PROCESS_UTIL
- show dependent code
CSI_CP_FORM_GRID_V
CSI_ML_UTIL_PVT
- show dependent code
CSI_ORGANIZATION_UNIT_PVT
- show dependent code
CSI_ORG_UNIT_VLD_PVT
- show dependent code
CSI_SYSTEMS_PVT
- show dependent code
CSI_SYSTEMS_V
CSP_PARTS_ORDER
- show dependent code
CSP_TRANSACTIONS_PUB
- show dependent code
CSTPOMLD
- show dependent code
CS_CHARGE_DETAILS_PVT
- show dependent code
CS_CORE_UTIL
- show dependent code
CS_COST_DETAILS_PVT
- show dependent code
CS_SERVICEREQUEST_UTIL
- show dependent code
DPP_ITEMCOST_PVT
- show dependent code
DPP_PRICING_PVT
- show dependent code
DPP_PURCHASEPRICE_PVT
- show dependent code
DPP_TRANSACTION_PVT
- show dependent code
DPP_UTILITY_PVT
- show dependent code
DPP_XLA_CLAIM_LINES_V
DPP_XLA_EVENT_PUB
- show dependent code
DPP_XLA_INV_LINES_V
FII_AR_UTIL_PKG
- show dependent code
FII_PMV_UTIL
- show dependent code
FND_MO_REPORTING_ENTITIES_V
FUN_AP_TRANSFER
- show dependent code
FUN_AR_BATCH_TRANSFER
- show dependent code
FUN_NET_ARAP_PKG
- show dependent code
FUN_NET_EXTRACT_PKG
- show dependent code
FUN_TRX_PVT
- show dependent code
GL_AS_POST_UPG_CHK_PKG
- show dependent code
GL_GLOBAL
- show dependent code
GL_JOURNAL_IMPORT_TAX_PKG
- show dependent code
GL_LEDGERS_PKG
- show dependent code
GMD_CUST_VEND_MST_V2
GMD_OUTBOUND_APIS_PUB
- show dependent code
GMD_QCR01USR_XMLP_PKG
- show dependent code
GMD_QC_ERES_UTILS
- show dependent code
GMD_QC_E_CUST_SAMPLE_DTLS_V
GMD_QC_E_CUST_SMPEVT_DTLS_V
GMD_QC_E_SUPP_SAMPLE_DTLS_V
GMD_QC_LABELS_UTIL
- show dependent code
GMD_QMSMC
- show dependent code
GMD_SAMPLES_PUB
- show dependent code
GMD_SPEC_VRS_GRP
- show dependent code
GMF_FND_GET_ORGANIZATION
- show dependent code
GMI_GMILTGEN_XMLP_PKG
- show dependent code
GMI_MOVE_ORDER_LINE_UTIL
- show dependent code
GML_GMLUNALC_XMLP_PKG
- show dependent code
GMS_OPERATING_UNITS_V
GR_PROCESS_ORDERS
- show dependent code
HR_ORGANIZATION_INTERNAL
- show dependent code
HXC_TIMEKEEPER_PROCESS
- show dependent code
HZ_MERGE_ADDRESSES_V
HZ_MGD_MASS_UPDATE_REP_GEN
- show dependent code
HZ_MO_GLOBAL_CACHE
- show dependent code
IBE_BI_STR_MIG_PVT
- show dependent code
IBY_UTILITY_PVT
- show dependent code
ICX_POR_EXT_DIAG
- show dependent code
IEX_AGING_CNSLD_INV_DETAILS_V
IEX_AGING_TRANSACTIONS_V
IEX_AG_TRX_V
IEX_CU_DLN_ALL_UWQ_V
IEX_CU_PRO_ALL_UWQ_V
IEX_CU_STR_UWQ_V
IEX_DELINQUENCIES_BALI_V
IEX_DELINQUENCIES_UWQ_V
IEX_DEL_V
IEX_DISPUTES_V
IEX_DUNNING_UWQ_V
IEX_LATER_STAGE_DELINQUENCY_V
IEX_METRIC_CONCUR_PVT
- show dependent code
IEX_OPEN_LINES_V
IEX_OPI_PVT
- show dependent code
IEX_PROFILE_DELINQUENCIES_V
IEX_PROMISES_UWQ_V
IEX_PROMISES_V
IEX_RECEIVABLE_APPLICATIONS_V
IEX_STRATEGIES_UWQ_V
IEX_STRATEGY_CNT_PUB
- show dependent code
IEX_TRANSACTIONS_V
IEX_TRANS_DEL_V
IEX_UWQ_DELIN_ENUMS_PVT
- show dependent code
IEX_UWQ_PROM_ENUMS_PVT
- show dependent code
IEX_UWQ_STRAT_ENUMS_PVT
- show dependent code
IGC_CC_OPN_UPD_GET_LNK_PUB
- show dependent code
IGC_CC_OPN_UPD_GET_LNK_PUB
- show dependent code
IGC_ETAX_UTIL_PKG
- show dependent code
IGC_IGCCAPRR_XMLP_PKG
- show dependent code
IGC_IGCCLDER_XMLP_PKG
- show dependent code
IGC_IGCCYRPR_XMLP_PKG
- show dependent code
IGI_CIS2007_IGIPPADR_PKG
- show dependent code
IGI_CIS2007_IGIPSUPR_PKG
- show dependent code
IGI_CIS_IGIPMTHP_PKG
- show dependent code
IGI_EXP_UTILS
- show dependent code
IGI_GCC_LEDGER_V
IGI_RPI_STANDING_CHARGES_V
IGI_SAP_GROUP_V
IGS_FI_CONTROL_V
INL_INTERFACE_PVT
- show dependent code
INV_EBI_ITEM_HELPER
- show dependent code
INV_THIRD_PARTY_STOCK_PVT
- show dependent code
INV_THIRD_PARTY_STOCK_UTIL
- show dependent code
INV_TRANSACTION_FLOW_PUB
- show dependent code
INV_TRANSACTION_FLOW_PVT
- show dependent code
INV_VIEW_MTL_TXN
- show dependent code
JAI_AR_TCS_REP_PKG
- show dependent code
JAI_CMN_UTILS_PKG
- show dependent code
JAI_CMN_UTILS_PKG
- show dependent code
JAI_OM_WDD_TRIGGER_PKG
- show dependent code
JAI_PA_BILLING_PKG
- show dependent code
JAI_PLSQL_CACHE_PKG
- show dependent code
JAI_PO_CSGT_BRIUD_T1
JAI_PO_CST_TRIGGER_PKG
- show dependent code
JAI_PO_HOOK_PKG
- show dependent code
JAI_PO_RLA_TRIGGER_PKG
- show dependent code
JAI_RGM_THHOLD_PROC_PKG
- show dependent code
JA_JAINAPCR_XMLP_PKG
- show dependent code
JA_JAINCTRB_XMLP_PKG
- show dependent code
JA_JAINPRRG_XMLP_PKG
- show dependent code
JE_IT_TAX_EX_UPGRADE2
- show dependent code
JG_JGZZSRCR_XMLP_PKG
- show dependent code
JL_BR_AR_RCT_MTHD_1_V
JMF_GTA_ARTRX_PROC
- show dependent code
JMF_GTA_REPORTS_PKG
- show dependent code
JMF_GTA_TRX_UTIL
- show dependent code
JMF_GTA_TXT_OPERATOR_PROC
- show dependent code
JMF_SHIKYU_RPT_CFR_PVT
- show dependent code
JTF_MSITE_GRP
- show dependent code
JTF_RS_CONC_RES_PUB
- show dependent code
JTF_RS_SUPPLIERS_VL
JTF_TERR_JSP_REPORTS
- show dependent code
JTF_TTY_WEBADI_TERR_GRP_V
JTY_MIGRATION_PVT
- show dependent code
JTY_WEBADI_OTH_TERR_DWNL_PKG
- show dependent code
JTY_WEBADI_OTH_TERR_DWNL_PKG
- show dependent code
LNS_BORROWERS_SUMMARY_PUB
- show dependent code
LNS_REP_UTILS
- show dependent code
MO_GLOBAL
- show dependent code
MO_GLOBAL
- show dependent code
MO_UTILS
- show dependent code
MTL_TRANSACTION_FLOW_HEADERS_V
MTL_TRANSACTION_FLOW_LINES_V
OE_AS_ORDER_HEADERS_V
OE_BULK_ORDER_IMPORT_PVT
- show dependent code
OE_CREDIT_CHECK_RPT
- show dependent code
OE_ERROR_WF
- show dependent code
OE_EXTERNAL_CREDIT_PVT
- show dependent code
OE_EXT_CREDIT_EXPOSURE_PVT
- show dependent code
OE_ITORD_PUB
- show dependent code
OE_QUERY
- show dependent code
OE_VALUE_TO_ID
- show dependent code
OKC_CA_UTIL_PVT
- show dependent code
OKC_CONTEXT
- show dependent code
OKC_CONTRACT_SEQ_PVT
- show dependent code
OKC_REP_SEARCH_UTIL_PVT
- show dependent code
OKC_TERMS_TEMPLATES_PVT
- show dependent code
OKC_TERMS_TMPL_APPROVAL_PVT
- show dependent code
OKC_XPRT_IMPORT_CLAUSES_PVT
- show dependent code
OKC_XPRT_IMPORT_TEMPLATE_PVT
- show dependent code
OKE_IMPORT_CONTRACT_PUB
- show dependent code
OKL_ACCOUNTING_PROCESS_PVT
- show dependent code
OKL_ACCRUAL_DEPRN_ADJ_PVT
- show dependent code
OKL_AE_TMPT_SETS_V
OKL_AM_ASSET_RETURN_PVT
- show dependent code
OKL_AM_BAL_WRITEOFF_PVT
- show dependent code
OKL_AM_BTCH_EXP_LEASE_LOAN_PVT
- show dependent code
OKL_AM_TERMINATE_INV_AGMT_PVT
- show dependent code
OKL_AM_TERMNT_INTERFACE_PVT
- show dependent code
OKL_AM_TERMNT_VENDOR_PRG_PVT
- show dependent code
OKL_AM_VENDOR_RES_SHARE_PVT
- show dependent code
OKL_ARINTF_PVT
- show dependent code
OKL_BILLING_CONTROLLER_PVT
- show dependent code
OKL_BILLING_RECON_RPT_PVT
- show dependent code
OKL_BPD_ADV_MON_RPT_PVT
- show dependent code
OKL_BPD_TERMINATION_ADJ_PVT
- show dependent code
OKL_CNTRCT_FIN_EXTRACT_PVT
- show dependent code
OKL_CONS_BILL
- show dependent code
OKL_CS_CONT_PARTY_UV
OKL_CS_CONT_SRCH_RESULTS_UV
OKL_CS_CUST_INS_POLICY_UV
OKL_DEAL_CREAT_PVT
- show dependent code
OKL_EXT_BILLING_CHARGES_PVT
- show dependent code
OKL_GENERATE_ACCRUALS_PVT
- show dependent code
OKL_GL_TRANSFER_PVT
- show dependent code
OKL_INTERNAL_TO_EXTERNAL
- show dependent code
OKL_INVESTOR_INVOICE_DISB_PVT
- show dependent code
OKL_INVOICE_FORMATS_V
OKL_INV_FORMATS_ALL_V
OKL_K_HDRS_FULL_UV
OKL_K_LINE_FIN_EXT_PVT
- show dependent code
OKL_LOSS_PROV_PVT
- show dependent code
OKL_MULTI_GAAP_PVT
- show dependent code
OKL_ORG_UNITS_UV
OKL_PAY_CURE_REFUNDS_PVT
- show dependent code
OKL_PAY_INVOICES_DISB_PVT
- show dependent code
OKL_PAY_INVOICES_MAN_PVT
- show dependent code
OKL_POOLCONC_PVT
- show dependent code
OKL_PROPERTY_TAX_STATEMENT_PVT
- show dependent code
OKL_PROP_TAX_ADJ_PVT
- show dependent code
OKL_PTM_PVT
- show dependent code
OKL_RECEIPT_DETAILS_UV
OKL_RECEIPT_SUMMARY_UV
OKL_REPORT_GENERATOR_PVT
- show dependent code
OKL_SEC_CONCURRENT_PVT
- show dependent code
OKL_STREAMS_RECON_PVT
- show dependent code
OKL_STREAM_BILLING_PUB
- show dependent code
OKL_STREAM_BILLING_PVT
- show dependent code
OKL_STREAM_MIGRATION_PVT
- show dependent code
OKL_SUBSIDIES_UV
OKL_SUB_PVT
- show dependent code
OKL_SVF_PVT
- show dependent code
OKL_TAS_PVT
- show dependent code
OKL_VARIABLE_INTEREST_PVT
- show dependent code
OKS_OKSFOSUM_XMLP_PKG
- show dependent code
OKS_OKSSCOFM_XMLP_PKG
- show dependent code
OKS_OMINT_PUB
- show dependent code
OKX_LEGAL_ENTITIES_V
OM_SETUP_VALID_PKG
- show dependent code
ONT_IMPLICITCUSTACCEPT_PVT
- show dependent code
ONT_OEXAUCRC_XMLP_PKG
- show dependent code
ONT_OEXCEXP_XMLP_PKG
- show dependent code
OZF_AUTOPAY_PVT
- show dependent code
OZF_AUTO_WRITEOFF_PVT
- show dependent code
OZF_CLAIMS_INT_PVT
- show dependent code
OZF_SD_BATCH_PVT
- show dependent code
OZF_SD_REQUEST_PUB
- show dependent code
OZF_SETTLEMENT_DOC_PVT
- show dependent code
OZF_WEBADI_INTERFACE_PVT
- show dependent code
PA_ASSIGNMENT_UTILS
- show dependent code
PA_CC_TP_BILL_SCH_ORG_V
PA_CC_TP_RULES_V
PA_CC_TP_UTILS
- show dependent code
PA_CC_TRANSFER_PRICE
- show dependent code
PA_MOAC_UTILS
- show dependent code
PA_MOAC_UTILS
- show dependent code
PA_OPERATING_UNITS_V
PA_PRVDR_CC_ORG_REL_V
PA_RECVR_CC_ORG_REL_V
PA_UTILS
- show dependent code
PER_RI_CONFIG_UTILITIES
- show dependent code
PJI_FM_SUM_PSI
- show dependent code
PJI_PJP_SUM_MAIN
- show dependent code
PMIFV_SALES_DETAILS_V
PMITS_QC_SAMPLES_V
PMI_REP_SALES_DETAILS_V
PMI_SALES_PKG
- show dependent code
PMI_SALES_PKG
- show dependent code
PN_GL_TRANSFER
- show dependent code
PN_PROFILE_UPGRADE
- show dependent code
POA_BIS_PPS_OPERU_LOV_V
POA_BIS_SAVINGS_OPERU_LOV_V
POA_CM_EVALUATION_ICX
- show dependent code
POA_CM_EVAL_SCORES_ICX
- show dependent code
POA_CM_OPER_UNIT_LOV_V
POA_REPORT_UTIL
- show dependent code
PON_PRINTING_PKG
- show dependent code
POS_EXCELASN_PVT
- show dependent code
POS_ORG_HASH_PKG
- show dependent code
POS_SECURITY_PROFILE_UTL_PKG
- show dependent code
POS_SUPPLIER_ADDRESS_PKG
- show dependent code
POS_VENDOR_PUB_PKG
- show dependent code
POS_VENDOR_REG_PKG
- show dependent code
PO_COPYDOC_SUB
- show dependent code
PO_CORE_S
- show dependent code
PO_CORE_S
- show dependent code
PO_CREATE_REQUISITION_SV
- show dependent code
PO_DRAFTS_PVT
- show dependent code
PO_ENCUMBRANCE_POSTPROCESSING
- show dependent code
PO_GA_ORG_ASSIGNMENTS_V
PO_MOAC_UTILS_PVT
- show dependent code
PO_R12_CAT_UPG_VAL_PVT
- show dependent code
PO_VENDORS_AP_V
QLTTRAWB
- show dependent code
QP_CRMINTEG_PRICELIST_V
QP_CROSS_ORDER_VOLUME_LOAD
- show dependent code
QP_UTIL
- show dependent code
RCV_ACCRUALUTILITIES_GRP
- show dependent code
WIP_BIS_UTZ_ALERT
- show dependent code
XLE_BUSINESSINFO_GRP
- show dependent code
XLE_BUSINESSINFO_GRP
- show dependent code
XLE_UTILITIES_GRP
- show dependent code
XTR_AP_OPEN_APLD_TRX_V
XTR_AP_OPEN_TRX_V
XTR_AP_ORIG_TRX_V
XTR_AR_OPEN_APLD_TRX_V
XTR_AR_OPEN_TRX_V
XTR_AR_ORIG_TRX_V
XTR_BIS_CASHFLOWS_V
XTR_CASH_FCST
- show dependent code
XTR_HEDGE_PROCESS_P
- show dependent code
XTR_XTRHOAPR_XMLP_PKG
- show dependent code
ZX_CORE_REP_EXTRACT_PKG
- show dependent code
ZX_FIRST_PARTY_ORGS_ALL_V
ZX_FIRST_PARTY_ORGS_MOAC_V
ZX_PTP_MIGRATE_PKG
- show dependent code
ZX_SIM_RULES_V
ZX_TRANSACTIONS_V
ZX_ZXAPJAJL_XMLP_PKG
- show dependent code
ZX_ZXARRECV_XMLP_PKG
- show dependent code
ZX_ZXXATB_XMLP_PKG
- show dependent code
PUBLIC
HR_OPERATING_UNITS
|
|
|
|