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

TABLE: XTR.XTR_HEDGE_JOURNAL_ACTIONS

Object Details
Object Name: XTR_HEDGE_JOURNAL_ACTIONS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_HEDGE_JOURNAL_ACTIONS
Subobject Name:
Status: VALID


Stores the hedge accounting structure information used to generate journals.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_HEDGE_JOURNAL_ACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPANY_CODE
Columns
Name Datatype Length Mandatory Comments
HEDGE_JOURNAL_ACTIONS_ID NUMBER (15) Yes Identifier for the hedge accounting entry.
COMPANY_CODE VARCHAR2 (7) Yes Company code of the hedge accounting.
DATE_TYPE VARCHAR2 (30) Yes Date type for the hedge accounting setup.
AMOUNT_TYPE VARCHAR2 (30) Yes Amount type for the hedge accounting setup.
ACTION_CODE VARCHAR2 (30) Yes Action code for the hedge accounting setup.
CREDIT_OR_DEBIT VARCHAR2 (2) Yes Credit or debit
CODE_COMBINATION_ID NUMBER (15)
GL account ID for the hedge accounting entry.
COMMENTS VARCHAR2 (255)
Comments
CREATED_BY NUMBER (15) Yes Standard WHO columns
CREATION_DATE DATE
Yes Standard WHO columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO columns
LAST_UPDATE_DATE DATE
Yes Standard WHO columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns
Query Text

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


SELECT HEDGE_JOURNAL_ACTIONS_ID
,      COMPANY_CODE
,      DATE_TYPE
,      AMOUNT_TYPE
,      ACTION_CODE
,      CREDIT_OR_DEBIT
,      CODE_COMBINATION_ID
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM XTR.XTR_HEDGE_JOURNAL_ACTIONS;

Dependencies

[top of page]

XTR.XTR_HEDGE_JOURNAL_ACTIONS does not reference any database object

XTR.XTR_HEDGE_JOURNAL_ACTIONS is referenced by following:

SchemaXTR
ViewXTR_HEDGE_JOURNAL_ACTIONS#