DBA Data[Home] [Help]

VIEW: PJI.PJI_FM_EXTR_PLNVER1#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, PROJECT_ID PROJECT_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ORG_ID PROJECT_ORG_ID, VERSION_ID VERSION_ID, PLAN_TYPE_CODE PLAN_TYPE_CODE, TIME_PHASED_TYPE_CODE TIME_PHASED_TYPE_CODE, CURRENT_FLAG CURRENT_FLAG, CURRENT_ORIGINAL_FLAG CURRENT_ORIGINAL_FLAG, DANGLING_FLAG DANGLING_FLAG, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, WORKER_ID WORKER_ID from "PJI"."PJI_FM_EXTR_PLNVER1"
View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, PROJECT_ID PROJECT_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, VERSION_ID VERSION_ID
, PLAN_TYPE_CODE PLAN_TYPE_CODE
, TIME_PHASED_TYPE_CODE TIME_PHASED_TYPE_CODE
, CURRENT_FLAG CURRENT_FLAG
, CURRENT_ORIGINAL_FLAG CURRENT_ORIGINAL_FLAG
, DANGLING_FLAG DANGLING_FLAG
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, WORKER_ID WORKER_ID
FROM "PJI"."PJI_FM_EXTR_PLNVER1"