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

VIEW: APPS.AZ_PRODUCT_PHASES_V

Object Details
Object Name: AZ_PRODUCT_PHASES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAZ.AZ_PRODUCT_PHASES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


AZ_PRODUCT_PHASES_V is a view that stores information about the phase
for each installed product defined in AZ_GROUPS. Each row includes
the unique identifier and name of an application as well as its
corresponding phase. This view is mainly used by the Define Phase
form.


[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application ID for this product
APPLICATION_NAME VARCHAR2 (240) Yes Application name for this product
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application short name for this product
PHASE NUMBER (15) Yes Implementation phase for this product
Query Text

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


SELECT APPLICATION_ID
,      APPLICATION_NAME
,      APPLICATION_SHORT_NAME
,      PHASE
FROM APPS.AZ_PRODUCT_PHASES_V;

Dependencies

[top of page]

APPS.AZ_PRODUCT_PHASES_V references the following:

SchemaAPPS
SynonymAZ_GROUPS
SynonymAZ_PRODUCT_PHASES
ViewFND_APPLICATION_VL
SynonymFND_PRODUCT_INSTALLATIONS
APPS.AZ_PRODUCT_PHASES_V is referenced by following:

SchemaAPPS
Package BodyAZW_REPORT - show dependent code