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

TABLE: QRM.QRM_DEALS_ANALYSES

Object Details
Object Name: QRM_DEALS_ANALYSES
Object Type: TABLE
Owner: QRM
FND Design Data: TableQRM.QRM_DEALS_ANALYSES
Subobject Name:
Status: VALID


QRM_DEALS_ANALYSES maps the deal calculations in QRM_DEAL_CALCULATIONS that belong to an analysis. Each row identifies a calculation within an analysis.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QRM_DEALS_ANALYSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_CALC_ID
ColumnANALYSIS_NAME
Columns
Name Datatype Length Mandatory Comments
DEAL_CALC_ID NUMBER
Yes Unique key identifying the calculations
ANALYSIS_NAME VARCHAR2 (20) Yes Name of the analysis
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER (15)
Concurrent request ID
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent program application ID
PROGRAM_ID NUMBER (15)
Concurrent program ID
PROGRAM_UPDATE_DATE DATE

Concurrent program update date
COMPANY_CODE VARCHAR2 (7) Yes Company code
Query Text

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


SELECT DEAL_CALC_ID
,      ANALYSIS_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMPANY_CODE
FROM QRM.QRM_DEALS_ANALYSES;

Dependencies

[top of page]

QRM.QRM_DEALS_ANALYSES does not reference any database object

QRM.QRM_DEALS_ANALYSES is referenced by following:

SchemaQRM
ViewQRM_DEALS_ANALYSES#