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

TABLE: PJI.PJI_FM_AGGR_FIN1

Object Details
Object Name: PJI_FM_AGGR_FIN1
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_AGGR_FIN1
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15)
Summarization state data
SLICE_ID NUMBER (15)
Summarization state data
TXN_ACCUM_HEADER_ID NUMBER

PROJECT_ID NUMBER (15)
Identifier of the Project
TASK_ID NUMBER (15)
Identifier of the Task
PERSON_ID NUMBER (15)
Identifier of the Person
PROJECT_ORG_ID NUMBER (15)
Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID NUMBER (15)
Identifier of the Project Organization
CUSTOMER_ID NUMBER (15)
Identifier of the Customer
EXPENDITURE_ORG_ID NUMBER (15)
Identifier of the Expenditure Operating Unit
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Identifier of the Expenditure Organization
JOB_ID NUMBER (15)
Identifier of the Job
VENDOR_ID NUMBER (15)
Identifier of the Vendor
WORK_TYPE_ID NUMBER (15)
Identifier of the Work Type
EXP_EVT_TYPE_ID NUMBER (15)
Identifier of the Expenditure/Event Type
EXPENDITURE_TYPE VARCHAR2 (30)
Identifier of the Expenditure Type
EVENT_TYPE VARCHAR2 (30)
Identifier of the Event Type
EVENT_TYPE_CLASSIFICATION VARCHAR2 (30)
Identifier of the Event Type Classification
EXPENDITURE_CATEGORY VARCHAR2 (30)
Identifier of the Expenditure Category
REVENUE_CATEGORY VARCHAR2 (30)
Identifier of the Revenue Category
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30)
System Linkage lookup
PJI_PROJECT_RECORD_FLAG VARCHAR2 (1)
Indicates whether the row will go to PJI FM
PJI_RESOURCE_RECORD_FLAG VARCHAR2 (1)
Indicates whether the row will go to PJI RM
CODE_COMBINATION_ID NUMBER (15)
Code Combination lookup
PRVDR_GL_DATE DATE

Resource GL transaction date
RECVR_GL_DATE DATE

Project GL transaction date
GL_PERIOD_NAME VARCHAR2 (15)
Identifier of the GL Period
PRVDR_PA_DATE DATE

Resource PA transaction date
RECVR_PA_DATE DATE

Project PA transaction date
PA_PERIOD_NAME VARCHAR2 (15)
Identifier of the PA Period
PRJ_REVENUE NUMBER

Revenue by project currency
PRJ_RAW_COST NUMBER

Raw Cost by project currency
PRJ_BILL_RAW_COST NUMBER

Billable Raw Cost by project currency
PRJ_BURDENED_COST NUMBER

Burdened Cost by project currency
PRJ_BILL_BURDENED_COST NUMBER

Billable Burdened Cost by project currency
POU_REVENUE NUMBER

Revenue by project functional currency
POU_RAW_COST NUMBER

Raw Cost by project functional currency
POU_BILL_RAW_COST NUMBER

Billable Raw Cost by project functional currency
POU_BURDENED_COST NUMBER

Burdened Cost by project functional currency
POU_BILL_BURDENED_COST NUMBER

Billable Burdened Cost by project functional currency
EOU_RAW_COST NUMBER

Raw Cost by expenditure functional currency
EOU_BILL_RAW_COST NUMBER

Billable Raw Cost by expenditure functional currency
EOU_BURDENED_COST NUMBER

Burdened Cost by expenditure functional currency
EOU_BILL_BURDENED_COST NUMBER

Bill Burdened Cost by expenditure functional currency
QUANTITY NUMBER

Actual Hours
BILL_QUANTITY NUMBER

Billable Actual Hours
EXPENDITURE_ITEM_DATE DATE

Expenditure Item transaction date
PROJECT_TYPE_CLASS VARCHAR2 (1)
Identifier of the project type class
NON_LABOR_RESOURCE VARCHAR2 (30)
Identifier of the Non Labor Resource
BOM_LABOR_RESOURCE_ID NUMBER (15)
Identifier of the Bill of Materials Labor Resource
BOM_EQUIPMENT_RESOURCE_ID NUMBER (15)
Identifier of the Bill of Materials Equipment Resource
INVENTORY_ITEM_ID NUMBER (15)
Identifier of the Inventory Item
TXN_CURRENCY_CODE VARCHAR2 (30)
Transaction Currency Code
TXN_REVENUE NUMBER

Revenue by transaction currency
TXN_RAW_COST NUMBER

Raw Cost by transaction currency
TXN_BILL_RAW_COST NUMBER

Billable Raw Cost by transaction currency
TXN_BURDENED_COST NUMBER

Burdened Cost by transaction currency
TXN_BILL_BURDENED_COST NUMBER

Billable Burdened Cost by transaction currency
TXN_UBR NUMBER

Unbilled Receivables by transaction currency
TXN_UER NUMBER

Unearned Revenue by transaction currency
PRJ_UBR NUMBER

Unbilled Receivables by project currency
PRJ_UER NUMBER

Unearned Revenue by project currency
POU_UBR NUMBER

Unbilled Receivables by project functional currency
POU_UER NUMBER

Unearned Revenue by project functional currency
EOU_UBR NUMBER

Unbilled Receivables by expenditure functional currency
EOU_UER NUMBER

Unearned Revenue by expenditure functional currency
PO_LINE_ID NUMBER

ASSIGNMENT_ID NUMBER (15)
CBS_ELEMENT_ID NUMBER (15)
The identifier of the cost code.
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 does not reference any database object

PJI.PJI_FM_AGGR_FIN1 is referenced by following:

SchemaPJI
ViewPJI_FM_AGGR_FIN1#