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


TABLE: POS.POS_ORG_HASH

Object Details
Object Name: POS_ORG_HASH
Object Type: TABLE
Owner: POS
FND Design Data: TablePOS.POS_ORG_HASH
Subobject Name:
Status: VALID


POS_ORG_HASH stores the hash key for operating unit identifiers. A hash key is an encrypted form of an operating unit identifier.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POS_ORG_HASH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHASHKEY
POS_ORG_HASH_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER
Yes Organization identifier
HASHKEY VARCHAR2 (60) Yes Hash key for the organization identifier
Query Text

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


SELECT ORG_ID
,      HASHKEY
FROM POS.POS_ORG_HASH;

Dependencies

[top of page]

POS.POS_ORG_HASH does not reference any database object

POS.POS_ORG_HASH is referenced by following:

SchemaPOS
ViewPOS_ORG_HASH#