[Home] [Help] [Dependency Information]
Object Name: | QPR_REPORT_TYPE_HDRS_B |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table stores the definitions of Price Planning Report Types.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_REPORT_TYPE_HEADER_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REPORT_TYPE_HEADER_ID |
SYS_IL0000457857C00006$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
QPR_REPORT_TYPE_HEADER_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REPORT_DOMAIN_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_TYPE_HEADER_ID | NUMBER | Yes | The unique indentifier for the report type entity | |
REPORT_DOMAIN_CODE | VARCHAR2 | (30) | Internal code to represent the functional domain classification of the report. | |
REPORT_LINE_MERGE_CODE | VARCHAR2 | (30) | Internal code to control the way the report type lines are merged to generate the report. | |
USER_ID | NUMBER | (15) | For future use | |
PLAN_ID | NUMBER | For future use | ||
REPORT_OPTIONS | CLOB | (4000) | XML data representing the report options menu. | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_TYPE_HEADER_ID
, REPORT_DOMAIN_CODE
, REPORT_LINE_MERGE_CODE
, USER_ID
, PLAN_ID
, REPORT_OPTIONS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM QPR.QPR_REPORT_TYPE_HDRS_B;
QPR.QPR_REPORT_TYPE_HDRS_B does not reference any database object
QPR.QPR_REPORT_TYPE_HDRS_B is referenced by following:
|
|
|