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

TABLE: APPLSYS.FND_IMP_PSMASTER2

Object Details
Object Name: FND_IMP_PSMASTER2
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_IMP_PSMASTER2
Subobject Name:
Status: VALID


FND_IMP_PSMASTER2


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_IMP_PSMASTER2_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSNAPSHOT_ID
ColumnPATCH_ID
ColumnAPP_SHORT_NAME
ColumnFILENAME
ColumnDIRECTORY
ColumnFILE_TYPE
ColumnTYPEID
FND_IMP_PSMASTER2_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTYPEID
Columns
Name Datatype Length Mandatory Comments
BUG_NO NUMBER

BUG_NO
SNAPSHOT_ID NUMBER

SNAPSHOT_ID
APP_SHORT_NAME VARCHAR2 (50)
APP_SHORT_NAME
DIRECTORY VARCHAR2 (160)
DIRECTORY
FILENAME VARCHAR2 (90)
FILENAME
TYPEID VARCHAR2 (11)
TYPEID
NEW_VERSION VARCHAR2 (30)
NEW_VERSION
OLD_VERSION VARCHAR2 (150)
OLD_VERSION
FILES_AFFECTED NUMBER

FILES_AFFECTED
TYPE_AFFECTED VARCHAR2 (4)
TYPE_AFFECTED
FILE_TYPE VARCHAR2 (90)
FILE_TYPE
TRANS_NAME VARCHAR2 (313)
TRANS_NAME
IS_FLAGGED_FILE VARCHAR2 (1)
Indicates if file is flagged
BRANCH_TYPE NUMBER

BRANCH_TYPE
PATCH_ID NUMBER

Generated number to uniquely indentify (bug_no, baseline) combination
Query Text

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


SELECT BUG_NO
,      SNAPSHOT_ID
,      APP_SHORT_NAME
,      DIRECTORY
,      FILENAME
,      TYPEID
,      NEW_VERSION
,      OLD_VERSION
,      FILES_AFFECTED
,      TYPE_AFFECTED
,      FILE_TYPE
,      TRANS_NAME
,      IS_FLAGGED_FILE
,      BRANCH_TYPE
,      PATCH_ID
FROM APPLSYS.FND_IMP_PSMASTER2;

Dependencies

[top of page]

APPLSYS.FND_IMP_PSMASTER2 does not reference any database object

APPLSYS.FND_IMP_PSMASTER2 is referenced by following:

SchemaAPPS
SynonymFND_IMP_PSMASTER2