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

TABLE: FTP.FTP_PP_ORGDATE_ASSUMP

Object Details
Object Name: FTP_PP_ORGDATE_ASSUMP
Object Type: TABLE
Owner: FTP
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTP_PP_ORGDATE_ASSUMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPPR_ASSUMPTION_ID
ColumnORIGINATION_DATE
Columns
Name Datatype Length Mandatory Comments
PPR_ASSUMPTION_ID NUMBER
Yes
OBJECT_DEFINITION_ID NUMBER (9) Yes
LINE_ITEM_ID NUMBER
Yes
CURRENCY VARCHAR2 (15) Yes
COND_SEQUENCE NUMBER
Yes
ORIGINATION_DATE DATE
Yes
CONST_PREPAY_RATE NUMBER

PREPAY_TBL_OBJECT_ID NUMBER (9)
BURNOUT_FACTOR NUMBER

ARC_COEFF_1 NUMBER

ARC_COEFF_2 NUMBER

ARC_COEFF_3 NUMBER

ARC_COEFF_4 NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT PPR_ASSUMPTION_ID
,      OBJECT_DEFINITION_ID
,      LINE_ITEM_ID
,      CURRENCY
,      COND_SEQUENCE
,      ORIGINATION_DATE
,      CONST_PREPAY_RATE
,      PREPAY_TBL_OBJECT_ID
,      BURNOUT_FACTOR
,      ARC_COEFF_1
,      ARC_COEFF_2
,      ARC_COEFF_3
,      ARC_COEFF_4
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM FTP.FTP_PP_ORGDATE_ASSUMP;

Dependencies

[top of page]

FTP.FTP_PP_ORGDATE_ASSUMP does not reference any database object

FTP.FTP_PP_ORGDATE_ASSUMP is referenced by following:

SchemaAPPS
SynonymFTP_PP_ORGDATE_ASSUMP