[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_PJI_CMT# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | (15) | ||
PJI_PROJECT_RECORD_FLAG | VARCHAR2 | (1) | ||
PJI_RESOURCE_RECORD_FLAG | VARCHAR2 | (1) | ||
PROJECT_ID | NUMBER | (15) | ||
PROJECT_ORG_ID | NUMBER | (15) | ||
PROJECT_ORGANIZATION_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | ||
EXPENDITURE_ORG_ID | NUMBER | (15) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | ||
WORK_TYPE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
PRVDR_GL_TIME_ID | NUMBER | (15) | ||
RECVR_GL_TIME_ID | NUMBER | (15) | ||
PRVDR_PA_TIME_ID | NUMBER | (15) | ||
RECVR_PA_TIME_ID | NUMBER | (15) | ||
PRJ_RAW_COST | NUMBER | |||
PRJ_BRDN_COST | NUMBER | |||
POU_RAW_COST | NUMBER | |||
POU_BRDN_COST | NUMBER | |||
GG_RAW_COST | NUMBER | |||
GG_BRDN_COST | NUMBER | |||
GP_RAW_COST | NUMBER | |||
GP_BRDN_COST | NUMBER | |||
EXPENDITURE_ITEM_TIME_ID | NUMBER | (15) | ||
EXP_EVT_TYPE_ID | NUMBER | (15) | ||
PROJECT_TYPE_CLASS | VARCHAR2 | (1) | ||
PJ_GL_CALENDAR_ID | NUMBER | (15) | ||
PJ_PA_CALENDAR_ID | NUMBER | (15) | ||
RS_GL_CALENDAR_ID | NUMBER | (15) | ||
RS_PA_CALENDAR_ID | NUMBER | (15) | ||
RECORD_TYPE | VARCHAR2 | (1) | ||
CMT_RECORD_TYPE | VARCHAR2 | (1) | ||
TASK_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EVENT_TYPE | VARCHAR2 | (30) | ||
EVENT_TYPE_CLASSIFICATION | VARCHAR2 | (30) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
REVENUE_CATEGORY | VARCHAR2 | (30) | ||
NON_LABOR_RESOURCE | VARCHAR2 | (30) | ||
BOM_LABOR_RESOURCE_ID | NUMBER | (15) | ||
BOM_EQUIPMENT_RESOURCE_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (30) | ||
GL_PERIOD_NAME | VARCHAR2 | (15) | ||
PA_PERIOD_NAME | VARCHAR2 | (15) | ||
TXN_CURRENCY_CODE | VARCHAR2 | (30) | ||
TXN_RAW_COST | NUMBER | |||
TXN_BRDN_COST | NUMBER | |||
EOU_RAW_COST | NUMBER | |||
EOU_BRDN_COST | NUMBER | |||
GG1_RAW_COST | NUMBER | |||
GG1_BRDN_COST | NUMBER | |||
GP1_RAW_COST | NUMBER | |||
GP1_BRDN_COST | NUMBER | |||
GG2_RAW_COST | NUMBER | |||
GG2_BRDN_COST | NUMBER | |||
GP2_RAW_COST | NUMBER | |||
GP2_BRDN_COST | NUMBER | |||
PO_LINE_ID | NUMBER | (15) | ||
RESOURCE_CLASS_CODE | VARCHAR2 | (30) | ||
ASSIGNMENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, PJI_PROJECT_RECORD_FLAG
, PJI_RESOURCE_RECORD_FLAG
, PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PERSON_ID
, EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID
, WORK_TYPE_ID
, JOB_ID
, PRVDR_GL_TIME_ID
, RECVR_GL_TIME_ID
, PRVDR_PA_TIME_ID
, RECVR_PA_TIME_ID
, PRJ_RAW_COST
, PRJ_BRDN_COST
, POU_RAW_COST
, POU_BRDN_COST
, GG_RAW_COST
, GG_BRDN_COST
, GP_RAW_COST
, GP_BRDN_COST
, EXPENDITURE_ITEM_TIME_ID
, EXP_EVT_TYPE_ID
, PROJECT_TYPE_CLASS
, PJ_GL_CALENDAR_ID
, PJ_PA_CALENDAR_ID
, RS_GL_CALENDAR_ID
, RS_PA_CALENDAR_ID
, RECORD_TYPE
, CMT_RECORD_TYPE
, TASK_ID
, VENDOR_ID
, EXPENDITURE_TYPE
, EVENT_TYPE
, EVENT_TYPE_CLASSIFICATION
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, NON_LABOR_RESOURCE
, BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID
, INVENTORY_ITEM_ID
, SYSTEM_LINKAGE_FUNCTION
, GL_PERIOD_NAME
, PA_PERIOD_NAME
, TXN_CURRENCY_CODE
, TXN_RAW_COST
, TXN_BRDN_COST
, EOU_RAW_COST
, EOU_BRDN_COST
, GG1_RAW_COST
, GG1_BRDN_COST
, GP1_RAW_COST
, GP1_BRDN_COST
, GG2_RAW_COST
, GG2_BRDN_COST
, GP2_RAW_COST
, GP2_BRDN_COST
, PO_LINE_ID
, RESOURCE_CLASS_CODE
, ASSIGNMENT_ID
FROM PJI.PJI_FM_PJI_CMT#;
|
|
|