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

TABLE: PA.PA_FIN7_OLAP

Object Details
Object Name: PA_FIN7_OLAP
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_FIN7_OLAP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
PA_FIN7_OLAP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
ColumnRECVR_PERIOD_ID
ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Partitioning column
RECORD_TYPE VARCHAR2 (1) Yes C / A for commitments or actuals slice
TXN_ACCUM_HEADER_ID NUMBER (15) Yes Transaction accum header
RESOURCE_CLASS_ID NUMBER (15) Yes Resource Class Identifier
PROJECT_ID NUMBER (15) Yes Project Identifier
PROJECT_ORG_ID NUMBER (15) Yes Project Operating Unit Identifier
PROJECT_ORGANIZATION_ID NUMBER (15) Yes Project Organization Identifier
PROJECT_TYPE_CLASS VARCHAR2 (1) Yes
TASK_ID NUMBER (15)
Task Identifier
RECVR_PERIOD_TYPE VARCHAR2 (15)
Receiver Period Type
RECVR_PERIOD_ID NUMBER (15)
Receiver 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
TXN_SUP_INV_COMMITTED_COST NUMBER

Supplier invoice commitment Cost by transaction currency.
TXN_PO_COMMITTED_COST NUMBER

Purchase order commitment Cost by transaction currency.
TXN_PR_COMMITTED_COST NUMBER

Purchase requisitions commitment Cost by transaction currency.
TXN_OTH_COMMITTED_COST NUMBER

Other commitment Cost by transaction currency.
PRJ_REVENUE NUMBER

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_REVENUE_WRITEOFF NUMBER

Revenue Write Off by project currency
PRJ_SUP_INV_COMMITTED_COST NUMBER

Supplier invoice commitment Cost by project currency.
PRJ_PO_COMMITTED_COST NUMBER

Purchase order commitment Cost by project currency.
PRJ_PR_COMMITTED_COST NUMBER

Purchase requisitions commitment Cost by project currency.
PRJ_OTH_COMMITTED_COST NUMBER

Other commitment Cost by project currency.
POU_REVENUE NUMBER

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_REVENUE_WRITEOFF NUMBER

Revenue Write Off by project functional currency
POU_SUP_INV_COMMITTED_COST NUMBER

Supplier invoice commitment Cost by project functional currency.
POU_PO_COMMITTED_COST NUMBER

Purchase order commitment Cost by project functional currency.
POU_PR_COMMITTED_COST NUMBER

Purchase requisitions commitment Cost by project functional currency.
POU_OTH_COMMITTED_COST NUMBER

Other commitment Cost by project functional 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
EOU_SUP_INV_COMMITTED_COST NUMBER

Supplier invoice commitment Cost by expenditure functional currency.
EOU_PO_COMMITTED_COST NUMBER

Purchase order commitment Cost by expenditure functional currency.
EOU_PR_COMMITTED_COST NUMBER

Purchase requisitions commitment Cost by expenditure functional currency.
EOU_OTH_COMMITTED_COST NUMBER

Other commitment Cost by expenditure functional currency.
QUANTITY NUMBER

Actual Hours
BILL_QUANTITY NUMBER

Billable Actual Hours
G1_REVENUE NUMBER

Revenue converted to primary global currency
G1_RAW_COST NUMBER

Raw Cost converted to primary global currency
G1_BRDN_COST NUMBER

Burdened Cost converted to primary global currency
G1_BILL_RAW_COST NUMBER

Billable Raw Cost converted to primary global currency
G1_BILL_BRDN_COST NUMBER

Billable Burdened Cost converted to primary global currency
G1_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to primary global currency
G1_SUP_INV_COMMITTED_COST NUMBER

Supplier invoice commitment Cost by primary global currency.
G1_PO_COMMITTED_COST NUMBER

Purchase order commitment Cost by primary global currency.
G1_PR_COMMITTED_COST NUMBER

Purchase requisitions commitment Cost by primary global currency.
G1_OTH_COMMITTED_COST NUMBER

Other commitment Cost by primary global currency.
G2_REVENUE NUMBER

Revenue converted to secondary global currency
G2_RAW_COST NUMBER

Raw Cost converted to secondary global currency
G2_BRDN_COST NUMBER

Burdened Cost converted to secondary global currency
G2_BILL_RAW_COST NUMBER

Billable Raw Cost converted to secondary global currency
G2_BILL_BRDN_COST NUMBER

Billable Burdened Cost converted to secondary global currency
G2_REVENUE_WRITEOFF NUMBER

Revenue Writeoff converted to secondary global currency
G2_SUP_INV_COMMITTED_COST NUMBER

Supplier invoice commitment Cost by secondary global currency.
G2_PO_COMMITTED_COST NUMBER

Purchase order commitment Cost by secondary global currency.
G2_PR_COMMITTED_COST NUMBER

Purchase requisitions commitment Cost by secondary global currency.
G2_OTH_COMMITTED_COST NUMBER

Other commitment Cost by secondary global currency.
ASSIGNMENT_ID NUMBER (15)
NAMED_ROLE VARCHAR2 (80)
CBS_ELEMENT_ID NUMBER

CBS_VERSION_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WORKER_ID
,      RECORD_TYPE
,      TXN_ACCUM_HEADER_ID
,      RESOURCE_CLASS_ID
,      PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_TYPE_CLASS
,      TASK_ID
,      RECVR_PERIOD_TYPE
,      RECVR_PERIOD_ID
,      TXN_CURRENCY_CODE
,      TXN_REVENUE
,      TXN_RAW_COST
,      TXN_BRDN_COST
,      TXN_BILL_RAW_COST
,      TXN_BILL_BRDN_COST
,      TXN_SUP_INV_COMMITTED_COST
,      TXN_PO_COMMITTED_COST
,      TXN_PR_COMMITTED_COST
,      TXN_OTH_COMMITTED_COST
,      PRJ_REVENUE
,      PRJ_RAW_COST
,      PRJ_BRDN_COST
,      PRJ_BILL_RAW_COST
,      PRJ_BILL_BRDN_COST
,      PRJ_REVENUE_WRITEOFF
,      PRJ_SUP_INV_COMMITTED_COST
,      PRJ_PO_COMMITTED_COST
,      PRJ_PR_COMMITTED_COST
,      PRJ_OTH_COMMITTED_COST
,      POU_REVENUE
,      POU_RAW_COST
,      POU_BRDN_COST
,      POU_BILL_RAW_COST
,      POU_BILL_BRDN_COST
,      POU_REVENUE_WRITEOFF
,      POU_SUP_INV_COMMITTED_COST
,      POU_PO_COMMITTED_COST
,      POU_PR_COMMITTED_COST
,      POU_OTH_COMMITTED_COST
,      EOU_REVENUE
,      EOU_RAW_COST
,      EOU_BRDN_COST
,      EOU_BILL_RAW_COST
,      EOU_BILL_BRDN_COST
,      EOU_SUP_INV_COMMITTED_COST
,      EOU_PO_COMMITTED_COST
,      EOU_PR_COMMITTED_COST
,      EOU_OTH_COMMITTED_COST
,      QUANTITY
,      BILL_QUANTITY
,      G1_REVENUE
,      G1_RAW_COST
,      G1_BRDN_COST
,      G1_BILL_RAW_COST
,      G1_BILL_BRDN_COST
,      G1_REVENUE_WRITEOFF
,      G1_SUP_INV_COMMITTED_COST
,      G1_PO_COMMITTED_COST
,      G1_PR_COMMITTED_COST
,      G1_OTH_COMMITTED_COST
,      G2_REVENUE
,      G2_RAW_COST
,      G2_BRDN_COST
,      G2_BILL_RAW_COST
,      G2_BILL_BRDN_COST
,      G2_REVENUE_WRITEOFF
,      G2_SUP_INV_COMMITTED_COST
,      G2_PO_COMMITTED_COST
,      G2_PR_COMMITTED_COST
,      G2_OTH_COMMITTED_COST
,      ASSIGNMENT_ID
,      NAMED_ROLE
,      CBS_ELEMENT_ID
,      CBS_VERSION_ID
FROM PA.PA_FIN7_OLAP;

Dependencies

[top of page]

PA.PA_FIN7_OLAP does not reference any database object

PA.PA_FIN7_OLAP is referenced by following:

SchemaPA
ViewPA_FIN7_OLAP#