Skip to content

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

TABLE: QA.QA_AHL_MR_DUMMY

Object Details
Object Name: QA_AHL_MR_DUMMY
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_AHL_MR_DUMMY
Subobject Name:
Status: VALID


A dummy table to mirror ahl_mr_headers_b. Oracle Internal use only - reserved for future use.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MR_HEADER_ID NUMBER
Yes Maintenance Requirement header ID
TITLE VARCHAR2 (80)
Title
VERSION_NUMBER NUMBER

Version number
EFFECTIVE_FROM DATE

Active date range
EFFECTIVE_TO DATE

Active date range
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
Query Text

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


SELECT MR_HEADER_ID
,      TITLE
,      VERSION_NUMBER
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM QA.QA_AHL_MR_DUMMY;

Dependencies

[top of page]

QA.QA_AHL_MR_DUMMY does not reference any database object

QA.QA_AHL_MR_DUMMY is referenced by following:

SchemaQA
ViewQA_AHL_MR_DUMMY#