DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_I_ORG_HCHY

Object Details
Object Name: DDR_I_ORG_HCHY
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Interface table to populate data in organization hierarchy tables


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_I_ORG_HCHY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_ID
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
ORG_CD VARCHAR2 (30)
Organization code
CHAIN_CD VARCHAR2 (30)
Organization chain code
CHAIN_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Chain level of organization
CHAIN_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
CHAIN_NAME VARCHAR2 (240)
Organization chain name
CHAIN_MGR_NAME VARCHAR2 (40)
Organization chain manager name
AREA_CD VARCHAR2 (30)
Organization area code
AREA_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Area level of organization
AREA_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
AREA_NAME VARCHAR2 (240)
Organization area name
AREA_MGR_NAME VARCHAR2 (40)
Organization area manager name
RGN_CD VARCHAR2 (30)
Organization region code
RGN_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Region level of organization
RGN_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
RGN_NAME VARCHAR2 (240)
Organization region name
RGN_MGR_NAME VARCHAR2 (40)
Organization region manager name
DSTRCT_CD VARCHAR2 (30)
Organization district code
DSTRCT_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a District level of organization
DSTRCT_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
DSTRCT_NAME VARCHAR2 (240)
Organization district name
DSTRCT_MGR_NAME VARCHAR2 (40)
Organization district manager name
BSNS_UNIT_CD VARCHAR2 (30)
Organization Business Unit code
BSNS_UNIT_GLBL_LOC_ID VARCHAR2 (30)
Universally Unique Global Location ID for a Business unit level of organization
BSNS_UNIT_GLBL_LOC_ID_TYP VARCHAR2 (30)
An indicator of the identification scheme used to assign the global Location ID.
BSNS_UNIT_NAME VARCHAR2 (240)
Organization Business Unit name
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REC_ID
,      ORG_CD
,      CHAIN_CD
,      CHAIN_GLBL_LOC_ID
,      CHAIN_GLBL_LOC_ID_TYP
,      CHAIN_NAME
,      CHAIN_MGR_NAME
,      AREA_CD
,      AREA_GLBL_LOC_ID
,      AREA_GLBL_LOC_ID_TYP
,      AREA_NAME
,      AREA_MGR_NAME
,      RGN_CD
,      RGN_GLBL_LOC_ID
,      RGN_GLBL_LOC_ID_TYP
,      RGN_NAME
,      RGN_MGR_NAME
,      DSTRCT_CD
,      DSTRCT_GLBL_LOC_ID
,      DSTRCT_GLBL_LOC_ID_TYP
,      DSTRCT_NAME
,      DSTRCT_MGR_NAME
,      BSNS_UNIT_CD
,      BSNS_UNIT_GLBL_LOC_ID
,      BSNS_UNIT_GLBL_LOC_ID_TYP
,      BSNS_UNIT_NAME
,      SRC_SYS_IDNT
,      SRC_SYS_DT
FROM DDR.DDR_I_ORG_HCHY;

Dependencies

[top of page]

DDR.DDR_I_ORG_HCHY does not reference any database object

DDR.DDR_I_ORG_HCHY is referenced by following:

SchemaDDR
ViewDDR_I_ORG_HCHY#