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

Object Details

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

[View Source]

Columns

Name	Datatype	Length
WORKER_ID	NUMBER	(15)
DANGLING_RECVR_GL_RATE_FLAG	VARCHAR2	(1)
DANGLING_RECVR_PA_RATE_FLAG	VARCHAR2	(1)
DANGLING_PRVDR_EN_TIME_FLAG	VARCHAR2	(1)
DANGLING_RECVR_EN_TIME_FLAG	VARCHAR2	(1)
DANGLING_RECVR_GL_TIME_FLAG	VARCHAR2	(1)
DANGLING_PRVDR_PA_TIME_FLAG	VARCHAR2	(1)
DANGLING_RECVR_PA_TIME_FLAG	VARCHAR2	(1)
ROW_ID	ROWID	(10)
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_REVENUE	NUMBER
PRJ_LABOR_REVENUE	NUMBER
PRJ_RAW_COST	NUMBER
PRJ_BRDN_COST	NUMBER
PRJ_BILL_RAW_COST	NUMBER
PRJ_BILL_BRDN_COST	NUMBER
PRJ_LABOR_RAW_COST	NUMBER
PRJ_LABOR_BRDN_COST	NUMBER
PRJ_BILL_LABOR_RAW_COST	NUMBER
PRJ_BILL_LABOR_BRDN_COST	NUMBER
PRJ_REVENUE_WRITEOFF	NUMBER
POU_REVENUE	NUMBER
POU_LABOR_REVENUE	NUMBER
POU_RAW_COST	NUMBER
POU_BRDN_COST	NUMBER
POU_BILL_RAW_COST	NUMBER
POU_BILL_BRDN_COST	NUMBER
POU_LABOR_RAW_COST	NUMBER
POU_LABOR_BRDN_COST	NUMBER
POU_BILL_LABOR_RAW_COST	NUMBER
POU_BILL_LABOR_BRDN_COST	NUMBER
POU_REVENUE_WRITEOFF	NUMBER
LABOR_HRS	NUMBER
BILL_LABOR_HRS	NUMBER
GG_REVENUE	NUMBER
GG_LABOR_REVENUE	NUMBER
GG_RAW_COST	NUMBER
GG_BRDN_COST	NUMBER
GG_BILL_RAW_COST	NUMBER
GG_BILL_BRDN_COST	NUMBER
GG_LABOR_RAW_COST	NUMBER
GG_LABOR_BRDN_COST	NUMBER
GG_BILL_LABOR_RAW_COST	NUMBER
GG_BILL_LABOR_BRDN_COST	NUMBER
GG_REVENUE_WRITEOFF	NUMBER
GP_REVENUE	NUMBER
GP_LABOR_REVENUE	NUMBER
GP_RAW_COST	NUMBER
GP_BRDN_COST	NUMBER
GP_BILL_RAW_COST	NUMBER
GP_BILL_BRDN_COST	NUMBER
GP_LABOR_RAW_COST	NUMBER
GP_LABOR_BRDN_COST	NUMBER
GP_BILL_LABOR_RAW_COST	NUMBER
GP_BILL_LABOR_BRDN_COST	NUMBER
GP_REVENUE_WRITEOFF	NUMBER
TOTAL_HRS_A	NUMBER
BILL_HRS_A	NUMBER
EXPENDITURE_ITEM_TIME_ID	NUMBER	(15)
DANGLING_PRVDR_GL_TIME_FLAG	VARCHAR2	(1)
DANGLING_EXP_EN_TIME_FLAG	VARCHAR2	(1)
DANGLING_EXP_GL_TIME_FLAG	VARCHAR2	(1)
DANGLING_EXP_PA_TIME_FLAG	VARCHAR2	(1)
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)
DANGLING_RECVR_GL_RATE2_FLAG	VARCHAR2	(1)
DANGLING_RECVR_PA_RATE2_FLAG	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_REVENUE	NUMBER
TXN_RAW_COST	NUMBER
TXN_BRDN_COST	NUMBER
TXN_BILL_RAW_COST	NUMBER
TXN_BILL_BRDN_COST	NUMBER
EOU_REVENUE	NUMBER
EOU_RAW_COST	NUMBER
EOU_BRDN_COST	NUMBER
EOU_BILL_RAW_COST	NUMBER
EOU_BILL_BRDN_COST	NUMBER
GG1_REVENUE	NUMBER
GG1_LABOR_REVENUE	NUMBER
GG1_RAW_COST	NUMBER
GG1_BRDN_COST	NUMBER
GG1_BILL_RAW_COST	NUMBER
GG1_BILL_BRDN_COST	NUMBER
GG1_LABOR_RAW_COST	NUMBER
GG1_LABOR_BRDN_COST	NUMBER
GG1_BILL_LABOR_RAW_COST	NUMBER
GG1_BILL_LABOR_BRDN_COST	NUMBER
GG1_REVENUE_WRITEOFF	NUMBER
GP1_REVENUE	NUMBER
GP1_LABOR_REVENUE	NUMBER
GP1_RAW_COST	NUMBER
GP1_BRDN_COST	NUMBER
GP1_BILL_RAW_COST	NUMBER
GP1_BILL_BRDN_COST	NUMBER
GP1_LABOR_RAW_COST	NUMBER
GP1_LABOR_BRDN_COST	NUMBER
GP1_BILL_LABOR_RAW_COST	NUMBER
GP1_BILL_LABOR_BRDN_COST	NUMBER
GP1_REVENUE_WRITEOFF	NUMBER
GG2_REVENUE	NUMBER
GG2_LABOR_REVENUE	NUMBER
GG2_RAW_COST	NUMBER
GG2_BRDN_COST	NUMBER
GG2_BILL_RAW_COST	NUMBER
GG2_BILL_BRDN_COST	NUMBER
GG2_LABOR_RAW_COST	NUMBER
GG2_LABOR_BRDN_COST	NUMBER
GG2_BILL_LABOR_RAW_COST	NUMBER
GG2_BILL_LABOR_BRDN_COST	NUMBER
GG2_REVENUE_WRITEOFF	NUMBER
GP2_REVENUE	NUMBER
GP2_LABOR_REVENUE	NUMBER
GP2_RAW_COST	NUMBER
GP2_BRDN_COST	NUMBER
GP2_BILL_RAW_COST	NUMBER
GP2_BILL_BRDN_COST	NUMBER
GP2_LABOR_RAW_COST	NUMBER
GP2_LABOR_BRDN_COST	NUMBER
GP2_BILL_LABOR_RAW_COST	NUMBER
GP2_BILL_LABOR_BRDN_COST	NUMBER
GP2_REVENUE_WRITEOFF	NUMBER
PO_LINE_ID	NUMBER
RESOURCE_CLASS_CODE	VARCHAR2	(30)
ASSIGNMENT_ID	NUMBER	(15)
CBS_ELEMENT_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WORKER_ID
,      DANGLING_RECVR_GL_RATE_FLAG
,      DANGLING_RECVR_PA_RATE_FLAG
,      DANGLING_PRVDR_EN_TIME_FLAG
,      DANGLING_RECVR_EN_TIME_FLAG
,      DANGLING_RECVR_GL_TIME_FLAG
,      DANGLING_PRVDR_PA_TIME_FLAG
,      DANGLING_RECVR_PA_TIME_FLAG
,      ROW_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_REVENUE
,      PRJ_LABOR_REVENUE
,      PRJ_RAW_COST
,      PRJ_BRDN_COST
,      PRJ_BILL_RAW_COST
,      PRJ_BILL_BRDN_COST
,      PRJ_LABOR_RAW_COST
,      PRJ_LABOR_BRDN_COST
,      PRJ_BILL_LABOR_RAW_COST
,      PRJ_BILL_LABOR_BRDN_COST
,      PRJ_REVENUE_WRITEOFF
,      POU_REVENUE
,      POU_LABOR_REVENUE
,      POU_RAW_COST
,      POU_BRDN_COST
,      POU_BILL_RAW_COST
,      POU_BILL_BRDN_COST
,      POU_LABOR_RAW_COST
,      POU_LABOR_BRDN_COST
,      POU_BILL_LABOR_RAW_COST
,      POU_BILL_LABOR_BRDN_COST
,      POU_REVENUE_WRITEOFF
,      LABOR_HRS
,      BILL_LABOR_HRS
,      GG_REVENUE
,      GG_LABOR_REVENUE
,      GG_RAW_COST
,      GG_BRDN_COST
,      GG_BILL_RAW_COST
,      GG_BILL_BRDN_COST
,      GG_LABOR_RAW_COST
,      GG_LABOR_BRDN_COST
,      GG_BILL_LABOR_RAW_COST
,      GG_BILL_LABOR_BRDN_COST
,      GG_REVENUE_WRITEOFF
,      GP_REVENUE
,      GP_LABOR_REVENUE
,      GP_RAW_COST
,      GP_BRDN_COST
,      GP_BILL_RAW_COST
,      GP_BILL_BRDN_COST
,      GP_LABOR_RAW_COST
,      GP_LABOR_BRDN_COST
,      GP_BILL_LABOR_RAW_COST
,      GP_BILL_LABOR_BRDN_COST
,      GP_REVENUE_WRITEOFF
,      TOTAL_HRS_A
,      BILL_HRS_A
,      EXPENDITURE_ITEM_TIME_ID
,      DANGLING_PRVDR_GL_TIME_FLAG
,      DANGLING_EXP_EN_TIME_FLAG
,      DANGLING_EXP_GL_TIME_FLAG
,      DANGLING_EXP_PA_TIME_FLAG
,      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
,      DANGLING_RECVR_GL_RATE2_FLAG
,      DANGLING_RECVR_PA_RATE2_FLAG
,      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_REVENUE
,      TXN_RAW_COST
,      TXN_BRDN_COST
,      TXN_BILL_RAW_COST
,      TXN_BILL_BRDN_COST
,      EOU_REVENUE
,      EOU_RAW_COST
,      EOU_BRDN_COST
,      EOU_BILL_RAW_COST
,      EOU_BILL_BRDN_COST
,      GG1_REVENUE
,      GG1_LABOR_REVENUE
,      GG1_RAW_COST
,      GG1_BRDN_COST
,      GG1_BILL_RAW_COST
,      GG1_BILL_BRDN_COST
,      GG1_LABOR_RAW_COST
,      GG1_LABOR_BRDN_COST
,      GG1_BILL_LABOR_RAW_COST
,      GG1_BILL_LABOR_BRDN_COST
,      GG1_REVENUE_WRITEOFF
,      GP1_REVENUE
,      GP1_LABOR_REVENUE
,      GP1_RAW_COST
,      GP1_BRDN_COST
,      GP1_BILL_RAW_COST
,      GP1_BILL_BRDN_COST
,      GP1_LABOR_RAW_COST
,      GP1_LABOR_BRDN_COST
,      GP1_BILL_LABOR_RAW_COST
,      GP1_BILL_LABOR_BRDN_COST
,      GP1_REVENUE_WRITEOFF
,      GG2_REVENUE
,      GG2_LABOR_REVENUE
,      GG2_RAW_COST
,      GG2_BRDN_COST
,      GG2_BILL_RAW_COST
,      GG2_BILL_BRDN_COST
,      GG2_LABOR_RAW_COST
,      GG2_LABOR_BRDN_COST
,      GG2_BILL_LABOR_RAW_COST
,      GG2_BILL_LABOR_BRDN_COST
,      GG2_REVENUE_WRITEOFF
,      GP2_REVENUE
,      GP2_LABOR_REVENUE
,      GP2_RAW_COST
,      GP2_BRDN_COST
,      GP2_BILL_RAW_COST
,      GP2_BILL_BRDN_COST
,      GP2_LABOR_RAW_COST
,      GP2_LABOR_BRDN_COST
,      GP2_BILL_LABOR_RAW_COST
,      GP2_BILL_LABOR_BRDN_COST
,      GP2_REVENUE_WRITEOFF
,      PO_LINE_ID
,      RESOURCE_CLASS_CODE
,      ASSIGNMENT_ID
,      CBS_ELEMENT_ID
FROM PJI.PJI_FM_AGGR_FIN2#;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_FIN2# references the following:

PJI: PJI_FM_AGGR_FIN2

PJI.PJI_FM_AGGR_FIN2# is referenced by following:

APPS: PJI_FM_AGGR_FIN2