[Home] [Help]
[Dependency Information]
Object Name: | HR_OPERATING_UNITS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
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;
|
|
|