[Home] [Help]
View: AZ_PRODUCT_PHASES_V
Product: | AZ - Application Implementation |
Description: | Stores language-dependent application names along with their phase information |
Implementation/DBA Data: |
APPS.AZ_PRODUCT_PHASES_V
|
View Text
SELECT APP.APPLICATION_ID
, FAV.APPLICATION_NAME
, FAV.APPLICATION_SHORT_NAME
, APP.PHASE
FROM AZ_PRODUCT_PHASES APP
, FND_APPLICATION_VL FAV
, FND_PRODUCT_INSTALLATIONS FPI
, AZ_GROUPS AZG
WHERE APP.APPLICATION_ID = FAV.APPLICATION_ID
AND FAV.APPLICATION_ID = FPI.APPLICATION_ID
AND FPI.STATUS = 'I'
AND FPI.APPLICATION_ID = AZG.APPLICATION_ID
AND AZG.PROCESS_TYPE = 'IMP'
Columns
Name |
APPLICATION_ID |
APPLICATION_NAME |
APPLICATION_SHORT_NAME |
PHASE |