VIEW: APPS.PA_BIS_PATH_NAME_LIST_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'