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.

VIEW: APPS.PABV_CLASSES

Source

View Text - Preformatted


SELECT ppa.project_id , pcc.class_category , pcc.class_code , ppc.LAST_UPDATE_DATE , ppc.LAST_UPDATED_BY , ppc.CREATION_DATE , ppc.CREATED_BY FROM pa_project_classes ppc, pa_class_codes pcc, pa_projects_all ppa WHERE ppc.project_id = ppa.project_id and ppc.class_code = pcc.class_code and ppc.class_category = pcc.class_category and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PCC.CLASS_CATEGORY
, PCC.CLASS_CODE
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
FROM PA_PROJECT_CLASSES PPC
, PA_CLASS_CODES PCC
, PA_PROJECTS_ALL PPA
WHERE PPC.PROJECT_ID = PPA.PROJECT_ID
AND PPC.CLASS_CODE = PCC.CLASS_CODE
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY