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

TABLE: APPLSYS.AD_PM_MASTER

Object Details
Object Name: AD_PM_MASTER
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.AD_PM_MASTER
Subobject Name:
Status: VALID


This table has only one row. Each time PAUpload concurrent program is run, this row is updated again by comparing the date from the Infobundle.zip file against the INFOBUNDLE_CREATION_DATE. If the newly downloaded file is older than that currently loaded in the database, the upload procedure will not be run


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AD_PM_MASTER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPATCH_METADATA_KEY
Columns
Name Datatype Length Mandatory Comments
PATCH_METADATA_KEY VARCHAR2 (20) Yes PRIMARY KEY
STAGING_DIRECTORY VARCHAR2 (255) Yes Directory where patches and the InfoBundle are downloaded. Also used for temporary files used by Patch Advisor
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
INFOBUNDLE_UPLOAD_DATE DATE

The DATE when PAUPLOAD Concurrent Program was last run
INFOBUNDLE_CREATION_DATE DATE

The DATE when the last InfoBudle uploaded was created by the ARU system
Query Text

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


SELECT PATCH_METADATA_KEY
,      STAGING_DIRECTORY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      INFOBUNDLE_UPLOAD_DATE
,      INFOBUNDLE_CREATION_DATE
FROM APPLSYS.AD_PM_MASTER;

Dependencies

[top of page]

APPLSYS.AD_PM_MASTER does not reference any database object

APPLSYS.AD_PM_MASTER is referenced by following:

SchemaAPPLSYS
ViewAD_PM_MASTER#