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 Mandatory Comments
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:

SchemaPJI
TablePJI_FM_AGGR_FIN2
PJI.PJI_FM_AGGR_FIN2# is referenced by following:

SchemaAPPS
SynonymPJI_FM_AGGR_FIN2