VIEW: PJI.PJI_FM_PJI_CMT#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, PJI_PROJECT_RECORD_FLAG PJI_PROJECT_RECORD_FLAG, PJI_RESOURCE_RECORD_FLAG PJI_RESOURCE_RECORD_FLAG, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PERSON_ID PERSON_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, WORK_TYPE_ID WORK_TYPE_ID, JOB_ID JOB_ID, PRVDR_GL_TIME_ID PRVDR_GL_TIME_ID, RECVR_GL_TIME_ID RECVR_GL_TIME_ID, PRVDR_PA_TIME_ID PRVDR_PA_TIME_ID, RECVR_PA_TIME_ID RECVR_PA_TIME_ID, PRJ_RAW_COST PRJ_RAW_COST, PRJ_BRDN_COST PRJ_BRDN_COST, POU_RAW_COST POU_RAW_COST, POU_BRDN_COST POU_BRDN_COST, GG_RAW_COST GG_RAW_COST, GG_BRDN_COST GG_BRDN_COST, GP_RAW_COST GP_RAW_COST, GP_BRDN_COST GP_BRDN_COST, EXPENDITURE_ITEM_TIME_ID EXPENDITURE_ITEM_TIME_ID, EXP_EVT_TYPE_ID EXP_EVT_TYPE_ID, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, PJ_GL_CALENDAR_ID PJ_GL_CALENDAR_ID, PJ_PA_CALENDAR_ID PJ_PA_CALENDAR_ID, RS_GL_CALENDAR_ID RS_GL_CALENDAR_ID, RS_PA_CALENDAR_ID RS_PA_CALENDAR_ID, RECORD_TYPE RECORD_TYPE, CMT_RECORD_TYPE CMT_RECORD_TYPE, TASK_ID TASK_ID, VENDOR_ID VENDOR_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EVENT_TYPE EVENT_TYPE, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY REVENUE_CATEGORY, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, GL_PERIOD_NAME GL_PERIOD_NAME, PA_PERIOD_NAME PA_PERIOD_NAME, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_RAW_COST TXN_RAW_COST, TXN_BRDN_COST TXN_BRDN_COST, EOU_RAW_COST EOU_RAW_COST, EOU_BRDN_COST EOU_BRDN_COST, GG1_RAW_COST GG1_RAW_COST, GG1_BRDN_COST GG1_BRDN_COST, GP1_RAW_COST GP1_RAW_COST, GP1_BRDN_COST GP1_BRDN_COST, GG2_RAW_COST GG2_RAW_COST, GG2_BRDN_COST GG2_BRDN_COST, GP2_RAW_COST GP2_RAW_COST, GP2_BRDN_COST GP2_BRDN_COST, PO_LINE_ID PO_LINE_ID, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, ASSIGNMENT_ID ASSIGNMENT_ID from "PJI"."PJI_FM_PJI_CMT"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, PJI_PROJECT_RECORD_FLAG PJI_PROJECT_RECORD_FLAG
, PJI_RESOURCE_RECORD_FLAG PJI_RESOURCE_RECORD_FLAG
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PERSON_ID PERSON_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, WORK_TYPE_ID WORK_TYPE_ID
, JOB_ID JOB_ID
, PRVDR_GL_TIME_ID PRVDR_GL_TIME_ID
, RECVR_GL_TIME_ID RECVR_GL_TIME_ID
, PRVDR_PA_TIME_ID PRVDR_PA_TIME_ID
, RECVR_PA_TIME_ID RECVR_PA_TIME_ID
, PRJ_RAW_COST PRJ_RAW_COST
, PRJ_BRDN_COST PRJ_BRDN_COST
, POU_RAW_COST POU_RAW_COST
, POU_BRDN_COST POU_BRDN_COST
, GG_RAW_COST GG_RAW_COST
, GG_BRDN_COST GG_BRDN_COST
, GP_RAW_COST GP_RAW_COST
, GP_BRDN_COST GP_BRDN_COST
, EXPENDITURE_ITEM_TIME_ID EXPENDITURE_ITEM_TIME_ID
, EXP_EVT_TYPE_ID EXP_EVT_TYPE_ID
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, PJ_GL_CALENDAR_ID PJ_GL_CALENDAR_ID
, PJ_PA_CALENDAR_ID PJ_PA_CALENDAR_ID
, RS_GL_CALENDAR_ID RS_GL_CALENDAR_ID
, RS_PA_CALENDAR_ID RS_PA_CALENDAR_ID
, RECORD_TYPE RECORD_TYPE
, CMT_RECORD_TYPE CMT_RECORD_TYPE
, TASK_ID TASK_ID
, VENDOR_ID VENDOR_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EVENT_TYPE EVENT_TYPE
, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY REVENUE_CATEGORY
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, GL_PERIOD_NAME GL_PERIOD_NAME
, PA_PERIOD_NAME PA_PERIOD_NAME
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BRDN_COST TXN_BRDN_COST
, EOU_RAW_COST EOU_RAW_COST
, EOU_BRDN_COST EOU_BRDN_COST
, GG1_RAW_COST GG1_RAW_COST
, GG1_BRDN_COST GG1_BRDN_COST
, GP1_RAW_COST GP1_RAW_COST
, GP1_BRDN_COST GP1_BRDN_COST
, GG2_RAW_COST GG2_RAW_COST
, GG2_BRDN_COST GG2_BRDN_COST
, GP2_RAW_COST GP2_RAW_COST
, GP2_BRDN_COST GP2_BRDN_COST
, PO_LINE_ID PO_LINE_ID
, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, ASSIGNMENT_ID ASSIGNMENT_ID
FROM "PJI"."PJI_FM_PJI_CMT"