eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.AD_PM_PATCHES

Object Details

Object Name:	AD_PM_PATCHES
Object Type:	TABLE
Owner:	APPLSYS
Subobject Name:
Status:	VALID

Lists all patches whose MetaData has been uploaded by Patch Advisor

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_PM_PATCHES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PATCH_METADATA_KEY BUG_NUMBER BASELINE
AD_PM_PATCHES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PATCH_METADATA_KEY	VARCHAR2	(20)	Yes	Primary Key Column
BUG_NUMBER	NUMBER		Yes	Primary Key Column
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.
ARU_UPDATE_DATE	DATE			Last time patch was updated by the ARU system
PRODUCT_ABBREVIATION	VARCHAR2	(15)		Abbreviation for the product that owns this patch.
PATCH_NAME	VARCHAR2	(80)		Patch Name
UPLOAD_RUN_ID	NUMBER			Concurrent Request ID for the Patch Upload run that last updated this row
BUG_DESCRIPTION	VARCHAR2	(240)		Description of Patch
IS_FAMILY_PACK	VARCHAR2	(1)		Is the patch a Family Pack?
IS_MINI_PACK	VARCHAR2	(1)		Is the patch a MiniPack?
IS_HIGH_PRIORITY	VARCHAR2	(1)		Is this a high-priority patch?
IS_MAINT_PACK	VARCHAR2	(1)		Is the patch a Maintenance Pack?
IN_REFERENCE_FAMILY_PACK	VARCHAR2	(1)		Is the patch included in the referenced Family Pack?
REFERENCE_FAMILY_PACK	NUMBER			Patch Number (Bug Number) for the Reference Family Pack (if any)
IN_REFERENCE_MINI_PACK	VARCHAR2	(1)		Is the patch included in the referenced MiniPack?
REFERENCE_MINI_PACK	NUMBER			Patch Number (Bug Number) of reference MiniPack (if any)
IN_REFERENCE_MAINT_PACK	VARCHAR2	(1)		Is the patch included in the reference Maintenance Pack?
REFERENCE_MAINT_PACK	NUMBER			Patch Number (Bug Number) of reference Maintenance Pack
INFOBUNDLE_UPLOAD_DATE	DATE			If this row was ever updated as part of uploading the InfoBundle, this colum records the date that happened.
README_FILE_ID	NUMBER			Foreign key to the row in FND_LOBS that contains the uploaded readme text for this patch
README_UPDATE_DATE	DATE			Date of the last InfoBundle upload that uploaded readme text.
PRODUCT_FAMILY_ABBREVIATION	VARCHAR2	(30)		Stores the abbreviation of the product.
IS_CODE_LEVEL	VARCHAR2	(1)		Is Codelevel patch?
ENTITY_ABBR	VARCHAR2	(30)		Abbreviation of entity for the patch
BASELINE	VARCHAR2	(150)		Baseline of patch - default R12
PATCH_ID	NUMBER		Yes	Primary Key for the patch
HAS_MSI_STEPS	VARCHAR2	(1)		Does the patch contain any MSI steps?
PATCH_TYPE	VARCHAR2	(50)		Patch type (Recommended, Minipack, Familypack, etc)

Query Text

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


SELECT PATCH_METADATA_KEY
,      BUG_NUMBER
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      ARU_UPDATE_DATE
,      PRODUCT_ABBREVIATION
,      PATCH_NAME
,      UPLOAD_RUN_ID
,      BUG_DESCRIPTION
,      IS_FAMILY_PACK
,      IS_MINI_PACK
,      IS_HIGH_PRIORITY
,      IS_MAINT_PACK
,      IN_REFERENCE_FAMILY_PACK
,      REFERENCE_FAMILY_PACK
,      IN_REFERENCE_MINI_PACK
,      REFERENCE_MINI_PACK
,      IN_REFERENCE_MAINT_PACK
,      REFERENCE_MAINT_PACK
,      INFOBUNDLE_UPLOAD_DATE
,      README_FILE_ID
,      README_UPDATE_DATE
,      PRODUCT_FAMILY_ABBREVIATION
,      IS_CODE_LEVEL
,      ENTITY_ABBR
,      BASELINE
,      PATCH_ID
,      HAS_MSI_STEPS
,      PATCH_TYPE
FROM APPLSYS.AD_PM_PATCHES;

Dependencies

[top of page]

APPLSYS.AD_PM_PATCHES does not reference any database object

APPLSYS.AD_PM_PATCHES is referenced by following:

APPS: AD_PM_PATCHES