Skip to content

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

VIEW: PJI.PJI_FM_AGGR_FIN1#

Object Details
Object Name: PJI_FM_AGGR_FIN1#
Object Type: VIEW
Owner: PJI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15)
SLICE_ID NUMBER (15)
TXN_ACCUM_HEADER_ID NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
PERSON_ID NUMBER (15)
PROJECT_ORG_ID NUMBER (15)
PROJECT_ORGANIZATION_ID NUMBER (15)
CUSTOMER_ID NUMBER (15)
EXPENDITURE_ORG_ID NUMBER (15)
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
JOB_ID NUMBER (15)
VENDOR_ID NUMBER (15)
WORK_TYPE_ID NUMBER (15)
EXP_EVT_TYPE_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EVENT_TYPE VARCHAR2 (30)
EVENT_TYPE_CLASSIFICATION VARCHAR2 (30)
EXPENDITURE_CATEGORY VARCHAR2 (30)
REVENUE_CATEGORY VARCHAR2 (30)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30)
PJI_PROJECT_RECORD_FLAG VARCHAR2 (1)
PJI_RESOURCE_RECORD_FLAG VARCHAR2 (1)
CODE_COMBINATION_ID NUMBER (15)
PRVDR_GL_DATE DATE

RECVR_GL_DATE DATE

GL_PERIOD_NAME VARCHAR2 (15)
PRVDR_PA_DATE DATE

RECVR_PA_DATE DATE

PA_PERIOD_NAME VARCHAR2 (15)
PRJ_REVENUE NUMBER

PRJ_RAW_COST NUMBER

PRJ_BILL_RAW_COST NUMBER

PRJ_BURDENED_COST NUMBER

PRJ_BILL_BURDENED_COST NUMBER

POU_REVENUE NUMBER

POU_RAW_COST NUMBER

POU_BILL_RAW_COST NUMBER

POU_BURDENED_COST NUMBER

POU_BILL_BURDENED_COST NUMBER

EOU_RAW_COST NUMBER

EOU_BILL_RAW_COST NUMBER

EOU_BURDENED_COST NUMBER

EOU_BILL_BURDENED_COST NUMBER

QUANTITY NUMBER

BILL_QUANTITY NUMBER

EXPENDITURE_ITEM_DATE DATE

PROJECT_TYPE_CLASS VARCHAR2 (1)
NON_LABOR_RESOURCE VARCHAR2 (30)
BOM_LABOR_RESOURCE_ID NUMBER (15)
BOM_EQUIPMENT_RESOURCE_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
TXN_CURRENCY_CODE VARCHAR2 (30)
TXN_REVENUE NUMBER

TXN_RAW_COST NUMBER

TXN_BILL_RAW_COST NUMBER

TXN_BURDENED_COST NUMBER

TXN_BILL_BURDENED_COST NUMBER

TXN_UBR NUMBER

TXN_UER NUMBER

PRJ_UBR NUMBER

PRJ_UER NUMBER

POU_UBR NUMBER

POU_UER NUMBER

EOU_UBR NUMBER

EOU_UER NUMBER

PO_LINE_ID NUMBER

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
,      SLICE_ID
,      TXN_ACCUM_HEADER_ID
,      PROJECT_ID
,      TASK_ID
,      PERSON_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      CUSTOMER_ID
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORGANIZATION_ID
,      JOB_ID
,      VENDOR_ID
,      WORK_TYPE_ID
,      EXP_EVT_TYPE_ID
,      EXPENDITURE_TYPE
,      EVENT_TYPE
,      EVENT_TYPE_CLASSIFICATION
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      SYSTEM_LINKAGE_FUNCTION
,      PJI_PROJECT_RECORD_FLAG
,      PJI_RESOURCE_RECORD_FLAG
,      CODE_COMBINATION_ID
,      PRVDR_GL_DATE
,      RECVR_GL_DATE
,      GL_PERIOD_NAME
,      PRVDR_PA_DATE
,      RECVR_PA_DATE
,      PA_PERIOD_NAME
,      PRJ_REVENUE
,      PRJ_RAW_COST
,      PRJ_BILL_RAW_COST
,      PRJ_BURDENED_COST
,      PRJ_BILL_BURDENED_COST
,      POU_REVENUE
,      POU_RAW_COST
,      POU_BILL_RAW_COST
,      POU_BURDENED_COST
,      POU_BILL_BURDENED_COST
,      EOU_RAW_COST
,      EOU_BILL_RAW_COST
,      EOU_BURDENED_COST
,      EOU_BILL_BURDENED_COST
,      QUANTITY
,      BILL_QUANTITY
,      EXPENDITURE_ITEM_DATE
,      PROJECT_TYPE_CLASS
,      NON_LABOR_RESOURCE
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIPMENT_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      TXN_CURRENCY_CODE
,      TXN_REVENUE
,      TXN_RAW_COST
,      TXN_BILL_RAW_COST
,      TXN_BURDENED_COST
,      TXN_BILL_BURDENED_COST
,      TXN_UBR
,      TXN_UER
,      PRJ_UBR
,      PRJ_UER
,      POU_UBR
,      POU_UER
,      EOU_UBR
,      EOU_UER
,      PO_LINE_ID
,      ASSIGNMENT_ID
,      CBS_ELEMENT_ID
FROM PJI.PJI_FM_AGGR_FIN1#;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_FIN1# references the following:

SchemaPJI
TablePJI_FM_AGGR_FIN1
PJI.PJI_FM_AGGR_FIN1# is referenced by following:

SchemaAPPS
SynonymPJI_FM_AGGR_FIN1