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

TABLE: PJI.PJI_FP_TXN_ACCUM_HEADER

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


This table stores the resource attribute combinations which are used for resource breakdown structure mapping


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_FP_TXN_ACCUM_HEADER_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTXN_ACCUM_HEADER_ID
PJI_FP_TXN_ACCUM_HEADER_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPERSON_ID
ColumnEXPENDITURE_TYPE_ID
ColumnINVENTORY_ITEM_ID
ColumnVENDOR_ID
ColumnEXPENDITURE_ORGANIZATION_ID
PJI_FP_TXN_ACCUM_HEADER_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnINVENTORY_ITEM_ID
PJI_FP_TXN_ACCUM_HEADER_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnVENDOR_ID
ColumnPROJECT_ROLE_ID
ColumnREVENUE_CATEGORY
ColumnRESOURCE_CLASS_ID
ColumnNON_LABOR_RESOURCE_ID
ColumnEXPENDITURE_ORGANIZATION_ID
ColumnJOB_ID
Columns
Name Datatype Length Mandatory Comments
TXN_ACCUM_HEADER_ID NUMBER (15) Yes Accum header Identifier
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
PERSON_ID NUMBER (15) Yes Person Identifier
EXPENDITURE_ORG_ID NUMBER (15) Yes Expenditure Operating Unit Identifier
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes Expenditure Organization Identifier
JOB_ID NUMBER (15) Yes Job Identifier
VENDOR_ID NUMBER (15) Yes Vendor Identifier
WORK_TYPE_ID NUMBER (15) Yes Work Type Identifier
EXP_EVT_TYPE_ID NUMBER (15) Yes Expenditure Event Type Identifier
EXPENDITURE_TYPE VARCHAR2 (30) Yes Expenditure Type
EVENT_TYPE VARCHAR2 (30) Yes Event Type
EVENT_TYPE_CLASSIFICATION VARCHAR2 (30) Yes Event Type Classification
EXPENDITURE_CATEGORY VARCHAR2 (30) Yes Expenditure Category
REVENUE_CATEGORY VARCHAR2 (30) Yes Revenue Category
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30) Yes System Linkage Function
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
RESOURCE_CLASS_ID NUMBER (15) Yes Resource Class Identifier
EXPENDITURE_CATEGORY_ID NUMBER (15) Yes Expenditure Category Identifier
EVENT_TYPE_ID NUMBER (15) Yes Event Type Identifier
NON_LABOR_RESOURCE_ID NUMBER (15) Yes Non Labor Resource Identifier
BOM_LABOR_RESOURCE_ID NUMBER (15) Yes BOM Labor resource identifier
BOM_EQUIPMENT_RESOURCE_ID NUMBER (15) Yes BOM Equipment resource identifier
ITEM_CATEGORY_ID NUMBER (15) Yes Item category Identifier
INVENTORY_ITEM_ID NUMBER (15) Yes Inventory Item Identifier
PROJECT_ROLE_ID NUMBER (15) Yes Project Role Identifier
NAMED_ROLE VARCHAR2 (80)
Named Role
EXPENDITURE_TYPE_ID NUMBER (15) Yes Expenditure Type Identifier
PERSON_TYPE VARCHAR2 (30)
Person Type
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 TXN_ACCUM_HEADER_ID
,      PROJECT_ID
,      TASK_ID
,      PERSON_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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RESOURCE_CLASS_ID
,      EXPENDITURE_CATEGORY_ID
,      EVENT_TYPE_ID
,      NON_LABOR_RESOURCE_ID
,      BOM_LABOR_RESOURCE_ID
,      BOM_EQUIPMENT_RESOURCE_ID
,      ITEM_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      PROJECT_ROLE_ID
,      NAMED_ROLE
,      EXPENDITURE_TYPE_ID
,      PERSON_TYPE
,      CBS_ELEMENT_ID
FROM PJI.PJI_FP_TXN_ACCUM_HEADER;

Dependencies

[top of page]

PJI.PJI_FP_TXN_ACCUM_HEADER does not reference any database object

PJI.PJI_FP_TXN_ACCUM_HEADER is referenced by following:

SchemaPJI
ViewPJI_FP_TXN_ACCUM_HEADER#