[Home] [Help]
View: PA_BIS_PATH_NAME_LIST_V
View Text
SELECT 'REVENUE'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_PATH_NAME_ORG')
, '01'
, 'ORGANIZATION'
, TO_CHAR(NULL)
, 'FIIPAORG.RDF'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_REV')||' - '||PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_PATH_NAME_ORG')
FROM DUAL UNION SELECT 'COST'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_PATH_NAME_ORG')
, '01'
, 'ORGANIZATION'
, TO_CHAR(NULL)
, 'FIIPAORG.RDF'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_COST')||' - '||PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_PATH_NAME_ORG')
FROM DUAL UNION SELECT 'REVENUE'
, CC.CLASS_CATEGORY
, CC.CLASS_CATEGORY
, CC.CLASS_CATEGORY
, CC.CLASS_CATEGORY
, 'FIIPACLS.RDF'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_REV')||' - '||CC.CLASS_CATEGORY
FROM PA_CLASS_CATEGORIES CC
WHERE CC.PICK_ONE_CODE_ONLY_FLAG = 'Y' UNION SELECT 'COST'
, CC.CLASS_CATEGORY
, CC.CLASS_CATEGORY
, CC.CLASS_CATEGORY
, CC.CLASS_CATEGORY
, 'FIIPACLS.RDF'
, PA_BIS_MESSAGES.GET_MESSAGE('PA'
, 'PA_BIS_AMT_TYPE_LABEL_COST')||' - '||CC.CLASS_CATEGORY
FROM PA_CLASS_CATEGORIES CC
WHERE CC.PICK_ONE_CODE_ONLY_FLAG = 'Y'
Columns
AMOUNT_TYPE_CODE |
DESCRIPTION |
SORT_ORDER |
PATH_NAME_CODE |
ENTITY_PARENT |
REPORT_NAME |
REPORT_HEADING |
Name |