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: PJI.PJI_AC_CUST_PJP0#

Source

View Text - Preformatted


select WORKER_ID WORKER_ID, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID, TIME_ID TIME_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, CALENDAR_TYPE CALENDAR_TYPE, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID, CURRENCY_CODE CURRENCY_CODE, CUSTOM1 CUSTOM1, CUSTOM2 CUSTOM2, CUSTOM3 CUSTOM3, CUSTOM4 CUSTOM4, CUSTOM5 CUSTOM5, CUSTOM6 CUSTOM6, CUSTOM7 CUSTOM7, CUSTOM8 CUSTOM8, CUSTOM9 CUSTOM9, CUSTOM10 CUSTOM10, CUSTOM11 CUSTOM11, CUSTOM12 CUSTOM12, CUSTOM13 CUSTOM13, CUSTOM14 CUSTOM14, CUSTOM15 CUSTOM15 from "PJI"."PJI_AC_CUST_PJP0"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID
, TIME_ID TIME_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID
, CURRENCY_CODE CURRENCY_CODE
, CUSTOM1 CUSTOM1
, CUSTOM2 CUSTOM2
, CUSTOM3 CUSTOM3
, CUSTOM4 CUSTOM4
, CUSTOM5 CUSTOM5
, CUSTOM6 CUSTOM6
, CUSTOM7 CUSTOM7
, CUSTOM8 CUSTOM8
, CUSTOM9 CUSTOM9
, CUSTOM10 CUSTOM10
, CUSTOM11 CUSTOM11
, CUSTOM12 CUSTOM12
, CUSTOM13 CUSTOM13
, CUSTOM14 CUSTOM14
, CUSTOM15 CUSTOM15
FROM "PJI"."PJI_AC_CUST_PJP0"