[Home] [Help] [Dependency Information]
Object Name: | PJI_FP_TXN_ACCUM1 |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FP_TXN_ACCUM1 |
Subobject Name: | |
Status: | VALID |
This table stores summarized commitment measures at project, task and periodic levels for project performance. This table contains the lowest level of summary amounts and does not include summaries by task and resource hierarchies
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PJI_FP_TXN_ACCUM1_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TXN_ACCUM_HEADER_ID | NUMBER | (15) | Yes | Transaction Accum Header 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 |
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 Code | |
TXN_SUP_INV_COMMITTED_COST | NUMBER | Supplier Invoice commitment Cost in transaction currency | ||
TXN_PO_COMMITTED_COST | NUMBER | Purchase Order commitment Cost in transaction currency | ||
TXN_PR_COMMITTED_COST | NUMBER | Purchase Requisitions commitment Cost in transaction currency | ||
TXN_OTH_COMMITTED_COST | NUMBER | Other commitment Cost in transaction currency | ||
PRJ_SUP_INV_COMMITTED_COST | NUMBER | Supplier Invoice commitment Cost in project currency | ||
PRJ_PO_COMMITTED_COST | NUMBER | Purchase Order commitment Cost in project currency | ||
PRJ_PR_COMMITTED_COST | NUMBER | Purchase Requisitions commitment Cost in project currency | ||
PRJ_OTH_COMMITTED_COST | NUMBER | Other commitment Cost in project currency | ||
POU_SUP_INV_COMMITTED_COST | NUMBER | Supplier Invoice commitment Cost in project functional currency | ||
POU_PO_COMMITTED_COST | NUMBER | Purchase Order commitment Cost in project functional currency | ||
POU_PR_COMMITTED_COST | NUMBER | Purchase Requisitions commitment Cost in project functional currency | ||
POU_OTH_COMMITTED_COST | NUMBER | Other commitment Cost in project functional currency | ||
EOU_SUP_INV_COMMITTED_COST | NUMBER | Supplier Invoice commitment Cost in expenditure functional currency | ||
EOU_PO_COMMITTED_COST | NUMBER | Purchase Order commitment Cost in expenditure functional currency | ||
EOU_PR_COMMITTED_COST | NUMBER | Purchase Requisitions commitment Cost in expenditure functional currency | ||
EOU_OTH_COMMITTED_COST | NUMBER | Other commitment Cost in expenditure functional currency | ||
G1_SUP_INV_COMMITTED_COST | NUMBER | Supplier Invoice commitment Cost in primary global currency | ||
G1_PO_COMMITTED_COST | NUMBER | Purchase Order commitment Cost in primary global currency | ||
G1_PR_COMMITTED_COST | NUMBER | Purchase Requisitions commitment Cost in primary global currency | ||
G1_OTH_COMMITTED_COST | NUMBER | Other commitment Cost in primary global currency | ||
G2_SUP_INV_COMMITTED_COST | NUMBER | Supplier Invoice commitment Cost in secondary global currency | ||
G2_PO_COMMITTED_COST | NUMBER | Purchase Order commitment Cost in secondary global currency | ||
G2_PR_COMMITTED_COST | NUMBER | Purchase Requisitions commitment Cost in secondary global currency | ||
G2_OTH_COMMITTED_COST | NUMBER | Other commitment Cost in secondary global currency | ||
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 | |
CBS_ELEMENT_ID | NUMBER | Stores CBS element id | ||
CBS_VERSION_ID | NUMBER | Stores CBS version id |
Cut, paste (and edit) the following text to query this object:
SELECT TXN_ACCUM_HEADER_ID
, PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, TASK_ID
, RECVR_PERIOD_TYPE
, RECVR_PERIOD_ID
, TXN_CURRENCY_CODE
, TXN_SUP_INV_COMMITTED_COST
, TXN_PO_COMMITTED_COST
, TXN_PR_COMMITTED_COST
, TXN_OTH_COMMITTED_COST
, PRJ_SUP_INV_COMMITTED_COST
, PRJ_PO_COMMITTED_COST
, PRJ_PR_COMMITTED_COST
, PRJ_OTH_COMMITTED_COST
, POU_SUP_INV_COMMITTED_COST
, POU_PO_COMMITTED_COST
, POU_PR_COMMITTED_COST
, POU_OTH_COMMITTED_COST
, EOU_SUP_INV_COMMITTED_COST
, EOU_PO_COMMITTED_COST
, EOU_PR_COMMITTED_COST
, EOU_OTH_COMMITTED_COST
, G1_SUP_INV_COMMITTED_COST
, G1_PO_COMMITTED_COST
, G1_PR_COMMITTED_COST
, G1_OTH_COMMITTED_COST
, G2_SUP_INV_COMMITTED_COST
, G2_PO_COMMITTED_COST
, G2_PR_COMMITTED_COST
, G2_OTH_COMMITTED_COST
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CBS_ELEMENT_ID
, CBS_VERSION_ID
FROM PJI.PJI_FP_TXN_ACCUM1;
PJI.PJI_FP_TXN_ACCUM1 does not reference any database object
PJI.PJI_FP_TXN_ACCUM1 is referenced by following:
|
|
|