eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_BIS_PATH_NAME_LIST_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.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

Name
AMOUNT_TYPE_CODE
DESCRIPTION
SORT_ORDER
PATH_NAME_CODE
ENTITY_PARENT
REPORT_NAME
REPORT_HEADING