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

TABLE: PJI.PJI_FM_PJI_CMT

Object Details
Object Name: PJI_FM_PJI_CMT
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15)
Summarization state data
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_RAW_COST NUMBER

Raw Cost by project currency
PRJ_BRDN_COST NUMBER

Burdened Cost by project currency
POU_RAW_COST NUMBER

Raw Cost by project functional currency
POU_BRDN_COST NUMBER

Burdened Cost by project functional currency
GG_RAW_COST NUMBER

GG_BRDN_COST NUMBER

GP_RAW_COST NUMBER

GP_BRDN_COST NUMBER

EXPENDITURE_ITEM_TIME_ID NUMBER (15)
Resource Expenditure Item transaction date
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
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_RAW_COST NUMBER

Raw Cost by transaction currency
TXN_BRDN_COST NUMBER

Burdened Cost by transaction currency
EOU_RAW_COST NUMBER

Raw Cost by expenditure functional currency
EOU_BRDN_COST NUMBER

Burdened Cost by expenditure functional currency
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
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
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
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
PO_LINE_ID NUMBER (15)
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
,      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_RAW_COST
,      PRJ_BRDN_COST
,      POU_RAW_COST
,      POU_BRDN_COST
,      GG_RAW_COST
,      GG_BRDN_COST
,      GP_RAW_COST
,      GP_BRDN_COST
,      EXPENDITURE_ITEM_TIME_ID
,      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
,      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_RAW_COST
,      TXN_BRDN_COST
,      EOU_RAW_COST
,      EOU_BRDN_COST
,      GG1_RAW_COST
,      GG1_BRDN_COST
,      GP1_RAW_COST
,      GP1_BRDN_COST
,      GG2_RAW_COST
,      GG2_BRDN_COST
,      GP2_RAW_COST
,      GP2_BRDN_COST
,      PO_LINE_ID
,      RESOURCE_CLASS_CODE
,      ASSIGNMENT_ID
FROM PJI.PJI_FM_PJI_CMT;

Dependencies

[top of page]

PJI.PJI_FM_PJI_CMT does not reference any database object

PJI.PJI_FM_PJI_CMT is referenced by following:

SchemaPJI
ViewPJI_FM_PJI_CMT#