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

TABLE: PJI.PJI_FM_AGGR_FIN2

Object Details
Object Name: PJI_FM_AGGR_FIN2
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_AGGR_FIN2
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
DANGLING_RECVR_GL_RATE_FLAG VARCHAR2 (1)
Indicates whether primary global currency rate is available on the GL transaction date
DANGLING_RECVR_PA_RATE_FLAG VARCHAR2 (1)
Indicates whether primary global currency rate is available on the PA transaction date
DANGLING_PRVDR_EN_TIME_FLAG VARCHAR2 (1)
Indicates whether the resource GL date is outside the enterprise calendar date range
DANGLING_RECVR_EN_TIME_FLAG VARCHAR2 (1)
Indicates whether the project GL date is outside the enterprise calendar date range
DANGLING_RECVR_GL_TIME_FLAG VARCHAR2 (1)
Indicates whether the project GL date is outside the GL calendar date range
DANGLING_PRVDR_PA_TIME_FLAG VARCHAR2 (1)
Indicates whether the resource PA date is outside the PA calendar date range
DANGLING_RECVR_PA_TIME_FLAG VARCHAR2 (1)
Indicates whether the project PA date is outside the PA calendar date range
ROW_ID ROWID (10)
Dangling table ROWID
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
PROJECT_ID NUMBER (15)
Identifier of the Project
PROJECT_ORG_ID NUMBER (15)
Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID NUMBER (15)
Identifier of the Project Organization
PERSON_ID NUMBER (15)
Identifier of the Person
EXPENDITURE_ORG_ID NUMBER (15)
Identifier of the Expenditure Operating Unit
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Identifier of the Expenditure Organization
WORK_TYPE_ID NUMBER (15)
Identifier of the Work Type
JOB_ID NUMBER (15)
Identifier of the Job
PRVDR_GL_TIME_ID NUMBER (15)
Resource GL transaction date
RECVR_GL_TIME_ID NUMBER (15)
Project GL transaction date
PRVDR_PA_TIME_ID NUMBER (15)
Resource PA transaction date
RECVR_PA_TIME_ID NUMBER (15)
Project PA transaction date
PRJ_REVENUE NUMBER

Revenue by project currency
PRJ_LABOR_REVENUE NUMBER

Labor Revenue by project currency
PRJ_RAW_COST NUMBER

Raw Cost by project currency
PRJ_BRDN_COST NUMBER

Burdened Cost by project currency
PRJ_BILL_RAW_COST NUMBER

Billable Raw Cost by project currency
PRJ_BILL_BRDN_COST NUMBER

Billable Burdened Cost by project currency
PRJ_LABOR_RAW_COST NUMBER

Labor Raw Cost by project currency
PRJ_LABOR_BRDN_COST NUMBER

Labor Burdened Cost by project currency
PRJ_BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost by project currency
PRJ_BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost by project currency
PRJ_REVENUE_WRITEOFF NUMBER

Revenue Write Off by project currency
POU_REVENUE NUMBER

Revenue by project functional currency
POU_LABOR_REVENUE NUMBER

Labor Revenue by project functional currency
POU_RAW_COST NUMBER

Raw Cost by project functional currency
POU_BRDN_COST NUMBER

Burdened Cost by project functional currency
POU_BILL_RAW_COST NUMBER

Billable Raw Cost by project functional currency
POU_BILL_BRDN_COST NUMBER

Billable Burdened Cost by project functional currency
POU_LABOR_RAW_COST NUMBER

Labor Raw Cost by project functional currency
POU_LABOR_BRDN_COST NUMBER

Labor Burdened Cost by project functional currency
POU_BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost by project functional currency
POU_BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost by project functional currency
POU_REVENUE_WRITEOFF NUMBER

Revenue Write Off by project functional currency
LABOR_HRS NUMBER

Labor Hours
BILL_LABOR_HRS NUMBER

Billable Labor Hours
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

Actual Hours
BILL_HRS_A NUMBER

Billable Actual Hours
EXPENDITURE_ITEM_TIME_ID NUMBER (15)
Resource Expenditure Item transaction date
DANGLING_PRVDR_GL_TIME_FLAG VARCHAR2 (1)
Indicates whether the resource GL date is outside the GL calendar date range
DANGLING_EXP_EN_TIME_FLAG VARCHAR2 (1)
Indicates whether the resource expenditure item date is outside the enterprise calendar date range
DANGLING_EXP_GL_TIME_FLAG VARCHAR2 (1)
Indicates whether the resource expenditure item date is outside the GL calendar date range
DANGLING_EXP_PA_TIME_FLAG VARCHAR2 (1)
Indicates whether the resource expenditure item date is outside the PA calendar date range
EXP_EVT_TYPE_ID NUMBER (15)
Identifier of the Expenditure / Event Type
PROJECT_TYPE_CLASS VARCHAR2 (1)
Identifier of the Project Type Class
PJ_GL_CALENDAR_ID NUMBER (15)
Project Operating Unit GL calendar
PJ_PA_CALENDAR_ID NUMBER (15)
Project Operating Unit PA calendar
RS_GL_CALENDAR_ID NUMBER (15)
Expenditure Operating Unit GL calendar
RS_PA_CALENDAR_ID NUMBER (15)
Expenditure Operating Unit PA calendar
RECORD_TYPE VARCHAR2 (1)
Data extraction type M = Commitments; A = Actuals
CMT_RECORD_TYPE VARCHAR2 (1)
Commitments record type I = Invoices; P = Purchase orders; R = Requisition orders; O = Others
DANGLING_RECVR_GL_RATE2_FLAG VARCHAR2 (1)
Indicates whether secondary global currency rate is available on the GL transaction date
DANGLING_RECVR_PA_RATE2_FLAG VARCHAR2 (1)
Indicates whether secondary global currency rate is available on the PA transaction date
TASK_ID NUMBER (15)
Identifier of the Task
VENDOR_ID NUMBER (15)
Identifier of the Vendor
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
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
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30)
System Linkage lookup
GL_PERIOD_NAME VARCHAR2 (15)
GL Period Name
PA_PERIOD_NAME VARCHAR2 (15)
PA Period Name
TXN_CURRENCY_CODE VARCHAR2 (30)
Transaction Currency
TXN_REVENUE NUMBER

Revenue by transaction currency
TXN_RAW_COST NUMBER

Raw Cost by transaction currency
TXN_BRDN_COST NUMBER

Burdened Cost by transaction currency
TXN_BILL_RAW_COST NUMBER

Billable Raw Cost by transaction currency
TXN_BILL_BRDN_COST NUMBER

Billable Burdened by transaction currency
EOU_REVENUE NUMBER

Revenue by expenditure functional currency
EOU_RAW_COST NUMBER

Raw Cost by expenditure functional currency
EOU_BRDN_COST NUMBER

Burdened Cost by expenditure functional currency
EOU_BILL_RAW_COST NUMBER

Billable Raw Cost by expenditure functional currency
EOU_BILL_BRDN_COST NUMBER

Billable Burdened Cost by expenditure functional currency
GG1_REVENUE NUMBER

Revenue converted to primary global currency on GL transaction date
GG1_LABOR_REVENUE NUMBER

Labor Revenue converted to primary global currency on GL transaction date
GG1_RAW_COST NUMBER

Raw Cost converted to primary global currency on GL transaction date
GG1_BRDN_COST NUMBER

Burdened Cost converted to primary global currency on GL transaction date
GG1_BILL_RAW_COST NUMBER

Billable Raw Cost converted to primary global currency on GL transaction date
GG1_BILL_BRDN_COST NUMBER

Billable Burdened Cost converted to primary global currency on GL transaction date
GG1_LABOR_RAW_COST NUMBER

Labor Raw Cost converted to primary global currency on GL transaction date
GG1_LABOR_BRDN_COST NUMBER

Labor Burdened Cost converted to primary global currency on GL transaction date
GG1_BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost converted to primary global currency on GL transaction date
GG1_BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost converted to primary global currency on GL transaction date
GG1_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to primary global currency on GL transaction date
GP1_REVENUE NUMBER

Revenue converted to primary global currency on PA transaction date
GP1_LABOR_REVENUE NUMBER

Labor Revenue converted to primary global currency on PA transaction date
GP1_RAW_COST NUMBER

Raw Cost converted to primary global currency on PA transaction date
GP1_BRDN_COST NUMBER

Burdened Cost converted to primary global currency on PA transaction date
GP1_BILL_RAW_COST NUMBER

Billable Raw Cost converted to primary global currency on PA transaction date
GP1_BILL_BRDN_COST NUMBER

Billable Burdened Cost converted to primary global currency on PA transaction date
GP1_LABOR_RAW_COST NUMBER

Labor Raw Cost converted to primary global currency on PA transaction date
GP1_LABOR_BRDN_COST NUMBER

Labor Burdened Cost converted to primary global currency on PA transaction date
GP1_BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost converted to primary global currency on PA transaction date
GP1_BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost converted to primary global currency on PA transaction date
GP1_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to primary global currency on PA transaction date
GG2_REVENUE NUMBER

Revenue converted to secondary global currency on GL transaction date
GG2_LABOR_REVENUE NUMBER

Labor Revenue converted to secondary global currency on GL transaction date
GG2_RAW_COST NUMBER

Raw Cost converted to secondary global currency on GL transaction date
GG2_BRDN_COST NUMBER

Burdened Cost converted to secondary global currency on GL transaction date
GG2_BILL_RAW_COST NUMBER

Billable Raw Cost converted to secondary global currency on GL transaction date
GG2_BILL_BRDN_COST NUMBER

Billable Burdened Cost converted to secondary global currency on GL transaction date
GG2_LABOR_RAW_COST NUMBER

Labor Raw Cost converted to secondary global currency on GL transaction date
GG2_LABOR_BRDN_COST NUMBER

Labor Burdened Cost converted to secondary global currency on GL transaction date
GG2_BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost converted to secondary global currency on GL transaction date
GG2_BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost converted to secondary global currency on GL transaction date
GG2_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to secondary global currency on GL transaction date
GP2_REVENUE NUMBER

Revenue converted to secondary global currency on PA transaction date
GP2_LABOR_REVENUE NUMBER

Labor Revenue converted to secondary global currency on PA transaction date
GP2_RAW_COST NUMBER

Raw Cost converted to secondary global currency on PA transaction date
GP2_BRDN_COST NUMBER

Burdened Cost converted to secondary global currency on PA transaction date
GP2_BILL_RAW_COST NUMBER

Billable Raw Cost converted to secondary global currency on PA transaction date
GP2_BILL_BRDN_COST NUMBER

Billable Burdened Cost converted to secondary global currency on PA transaction date
GP2_LABOR_RAW_COST NUMBER

Labor Raw Cost converted to secondary global currency on PA transaction date
GP2_LABOR_BRDN_COST NUMBER

Labor Burdened Cost converted to secondary global currency on PA transaction date
GP2_BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost converted to secondary global currency on PA transaction date
GP2_BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost converted to secondary global currency on PA transaction date
GP2_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to secondary global currency on PA transaction date
PO_LINE_ID NUMBER

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
,      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
FROM PJI.PJI_FM_AGGR_FIN2;

Dependencies

[top of page]

PJI.PJI_FM_AGGR_FIN2 does not reference any database object

PJI.PJI_FM_AGGR_FIN2 is referenced by following:

SchemaAPPS
SynonymPJI_FM_AGGR_FIN2