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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PJI.PJI_FM_PJI_CMT#

Object Details

Object Name:	PJI_FM_PJI_CMT#
Object Type:	VIEW
Owner:	PJI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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)

Query Text

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#;

Dependencies

[top of page]

PJI.PJI_FM_PJI_CMT# references the following:

PJI: PJI_FM_PJI_CMT

PJI.PJI_FM_PJI_CMT# is referenced by following:

APPS: PJI_FM_PJI_CMT