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

TABLE: OKL.OKL_ACCRUAL_PROCESSING

Object Details
Object Name: OKL_ACCRUAL_PROCESSING
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_ACCRUAL_PROCESSING
Subobject Name:
Status: VALID


This table is used only by the accrual program to process accruals.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_ACCRUAL_PROCESSING_NU1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROW_NUMBER
Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER

Contract Identifier
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
START_DATE DATE

Contract Start Date
STS_CODE VARCHAR2 (120)
Contract Status Code
PDT_ID NUMBER

Product Identifier
GENERATE_ACCRUAL_YN VARCHAR2 (3)
Contract Accrual Status
GENERATE_ACCRUAL_OVERRIDE_YN VARCHAR2 (3)
Contract Accrual override status
DEAL_TYPE VARCHAR2 (30)
Book Classification
CURRENCY_CODE VARCHAR2 (120)
Contract Currency Code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Contract Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Contract Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Contract Currency Conversion Date
ROW_NUMBER NUMBER

Row Number
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      START_DATE
,      STS_CODE
,      PDT_ID
,      GENERATE_ACCRUAL_YN
,      GENERATE_ACCRUAL_OVERRIDE_YN
,      DEAL_TYPE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ROW_NUMBER
FROM OKL.OKL_ACCRUAL_PROCESSING;

Dependencies

[top of page]

OKL.OKL_ACCRUAL_PROCESSING does not reference any database object

OKL.OKL_ACCRUAL_PROCESSING is referenced by following:

SchemaAPPS
SynonymOKL_ACCRUAL_PROCESSING