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

TABLE: HR.PAY_COST_ALLOCATION_KEYFLEX

Object Details
Object Name: PAY_COST_ALLOCATION_KEYFLEX
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_COST_ALLOCATION_KEYFLEX
Subobject Name:
Status: VALID


PAY_COST_ALLOCATION_KEYFLEX is the combinations table for the Cost
Allocation key flexfield. This includes the individual segment
information that identify the cost codes, accounts and labor
distribution codes used in specific Business Groups.
CONCATENATED_SEGMENTS contains the concatenated value of
SEGMENT1 to SEGMENT30.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_COST_ALLOCATION_KEYFLE_PK
  1. ColumnCOST_ALLOCATION_KEYFLEX_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_COST_ALLOCATION_KEYFLE_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_ALLOCATION_KEYFLEX_ID
PAY_COST_ALLOCATION_KEYFLEX_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnID_FLEX_NUM
ColumnENABLED_FLAG
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK2 PAY_COST_ALLOCATION_KEYFLEX HR_ALL_ORGANIZATION_UNITS COST_ALLOCATION_KEYFLEX_ID
TablePAY_ALL_PAYROLLS_F PAY_PAYROLLS_F_FK4 PAY_COST_ALLOCATION_KEYFLEX PAY_ALL_PAYROLLS_F COST_ALLOCATION_KEYFLEX_ID
TablePAY_ALL_PAYROLLS_F PAY_PAYROLLS_F_FK5 PAY_COST_ALLOCATION_KEYFLEX PAY_ALL_PAYROLLS_F SUSPENSE_ACCOUNT_KEYFLEX_ID
TablePAY_COSTS PAY_COSTS_FK3 PAY_COST_ALLOCATION_KEYFLEX PAY_COSTS COST_ALLOCATION_KEYFLEX_ID
TablePAY_COST_ALLOCATIONS_F PAY_COST_ALLOCATIONS_F_FK2 PAY_COST_ALLOCATION_KEYFLEX PAY_COST_ALLOCATIONS_F COST_ALLOCATION_KEYFLEX_ID
TablePAY_ELEMENT_ENTRIES_F PAY_ELEMENT_ENTRIES_F_FK1 PAY_COST_ALLOCATION_KEYFLEX PAY_ELEMENT_ENTRIES_F COST_ALLOCATION_KEYFLEX_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK5 PAY_COST_ALLOCATION_KEYFLEX PAY_ELEMENT_LINKS_F COST_ALLOCATION_KEYFLEX_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK10 PAY_COST_ALLOCATION_KEYFLEX PAY_ELEMENT_LINKS_F BALANCING_KEYFLEX_ID
TablePQH_BUDGET_FUND_SRCS PQH_BUDGET_FUND_SRCS_FK2 PAY_COST_ALLOCATION_KEYFLEX PQH_BUDGET_FUND_SRCS COST_ALLOCATION_KEYFLEX_ID
TablePQH_DFLT_FUND_SRCS PQH_DFLT_FUND_SRCS_FK2 PAY_COST_ALLOCATION_KEYFLEX PQH_DFLT_FUND_SRCS COST_ALLOCATION_KEYFLEX_ID
TablePQH_WORKSHEET_FUND_SRCS PQH_WORKSHEET_FUND_SRCS_FK2 PAY_COST_ALLOCATION_KEYFLEX PQH_WORKSHEET_FUND_SRCS COST_ALLOCATION_KEYFLEX_ID
Columns
Name Datatype Length Mandatory Comments
COST_ALLOCATION_KEYFLEX_ID NUMBER (9) Yes System-generated primary key column.
CONCATENATED_SEGMENTS VARCHAR2 (2000)
Key flexfield segment column.
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure foreign key.
SUMMARY_FLAG VARCHAR2 (1) Yes Key flexfield summary flag.
ENABLED_FLAG VARCHAR2 (1) Yes Key flexfield enabled flag.
START_DATE_ACTIVE DATE

Date before which key flexfield combination is invalid.
END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment
SEGMENT2 VARCHAR2 (60)
Key flexfield segment
SEGMENT3 VARCHAR2 (60)
Key flexfield segment
SEGMENT4 VARCHAR2 (60)
Key flexfield segment
SEGMENT5 VARCHAR2 (60)
Key flexfield segment
SEGMENT6 VARCHAR2 (60)
Key flexfield segment
SEGMENT7 VARCHAR2 (60)
Key flexfield segment
SEGMENT8 VARCHAR2 (60)
Key flexfield segment
SEGMENT9 VARCHAR2 (60)
Key flexfield segment
SEGMENT10 VARCHAR2 (60)
Key flexfield segment
SEGMENT11 VARCHAR2 (60)
Key flexfield segment
SEGMENT12 VARCHAR2 (60)
Key flexfield segment
SEGMENT13 VARCHAR2 (60)
Key flexfield segment
SEGMENT14 VARCHAR2 (60)
Key flexfield segment
SEGMENT15 VARCHAR2 (60)
Key flexfield segment
SEGMENT16 VARCHAR2 (60)
Key flexfield segment
SEGMENT17 VARCHAR2 (60)
Key flexfield segment
SEGMENT18 VARCHAR2 (60)
Key flexfield segment
SEGMENT19 VARCHAR2 (60)
Key flexfield segment
SEGMENT20 VARCHAR2 (60)
Key flexfield segment
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
Key flexfield segment column.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

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


SELECT COST_ALLOCATION_KEYFLEX_ID
,      CONCATENATED_SEGMENTS
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_COST_ALLOCATION_KEYFLEX;

Dependencies

[top of page]

HR.PAY_COST_ALLOCATION_KEYFLEX does not reference any database object

HR.PAY_COST_ALLOCATION_KEYFLEX is referenced by following:

SchemaHR
ViewPAY_COST_ALLOCATION_KEYFLEX#