[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_AGGR_FIN1 |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_AGGR_FIN1 |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 0 |
PCT Used: |
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) |
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
FROM PJI.PJI_FM_AGGR_FIN1;
PJI.PJI_FM_AGGR_FIN1 does not reference any database object
PJI.PJI_FM_AGGR_FIN1 is referenced by following:
|
|
|