DBA Data[Home] [Help]

VIEW: APPS.PA_ADW_CLASS_CODES_B_V

Source

View Text - Preformatted

SELECT PPCD.CLASS_CATEGORY , PPCD.CLASS_CODE , PPCD.DESCRIPTION , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PPCD.ADW_NOTIFY_FLAG FROM PA_CLASS_CODES PPCD, PA_ADW_CLASS_CATGS_B_V PCC WHERE PPCD.CLASS_CATEGORY = PCC.CLASS_CATEGORY
View Text - HTML Formatted

SELECT PPCD.CLASS_CATEGORY
, PPCD.CLASS_CODE
, PPCD.DESCRIPTION
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PPCD.ADW_NOTIFY_FLAG
FROM PA_CLASS_CODES PPCD
, PA_ADW_CLASS_CATGS_B_V PCC
WHERE PPCD.CLASS_CATEGORY = PCC.CLASS_CATEGORY