[Home] [Help] [Dependency Information]
Object Name: | PA_PJT_FACT_PERIOD |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PJT_FACT_PERIOD |
Subobject Name: | |
Status: | VALID |
PA.PA_PJT_FACT_PERIOD is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PJT_FACT_PERIOD_N1 | NORMAL | NONUNIQUE |
PROJECT_ID
START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | |
PERIOD_ID | NUMBER | (15) | Yes | |
START_DATE | DATE | Yes | ||
PLAN_VERSION_ID | NUMBER | (15) | Yes | |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
RAW_COST | NUMBER | |||
BRDN_COST | NUMBER | |||
REVENUE | NUMBER | |||
BILL_RAW_COST | NUMBER | |||
BILL_BRDN_COST | NUMBER | |||
BILL_LABOR_RAW_COST | NUMBER | |||
BILL_LABOR_BRDN_COST | NUMBER | |||
BILL_LABOR_HRS | NUMBER | |||
EQUIPMENT_RAW_COST | NUMBER | |||
EQUIPMENT_BRDN_COST | NUMBER | |||
CAPITALIZABLE_RAW_COST | NUMBER | |||
CAPITALIZABLE_BRDN_COST | NUMBER | |||
LABOR_RAW_COST | NUMBER | |||
LABOR_BRDN_COST | NUMBER | |||
LABOR_HRS | NUMBER | |||
LABOR_REVENUE | NUMBER | |||
EQUIPMENT_HOURS | NUMBER | |||
BILLABLE_EQUIPMENT_HOURS | NUMBER | |||
SUP_INV_COMMITTED_COST | NUMBER | |||
PO_COMMITTED_COST | NUMBER | |||
PR_COMMITTED_COST | NUMBER | |||
OTH_COMMITTED_COST | NUMBER | |||
ACT_LABOR_HRS | NUMBER | |||
ACT_EQUIP_HRS | NUMBER | |||
ACT_LABOR_BRDN_COST | NUMBER | |||
ACT_EQUIP_BRDN_COST | NUMBER | |||
ACT_BRDN_COST | NUMBER | |||
ACT_RAW_COST | NUMBER | |||
ACT_REVENUE | NUMBER | |||
ETC_LABOR_HRS | NUMBER | |||
ETC_EQUIP_HRS | NUMBER | |||
ETC_LABOR_BRDN_COST | NUMBER | |||
ETC_EQUIP_BRDN_COST | NUMBER | |||
ETC_BRDN_COST | NUMBER | |||
ETC_RAW_COST | NUMBER | |||
ACT_LABOR_RAW_COST | NUMBER | |||
ACT_EQUIP_RAW_COST | NUMBER | |||
ETC_LABOR_RAW_COST | NUMBER | |||
ETC_EQUIP_RAW_COST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PERIOD_ID
, START_DATE
, PLAN_VERSION_ID
, CURRENCY_CODE
, RAW_COST
, BRDN_COST
, REVENUE
, BILL_RAW_COST
, BILL_BRDN_COST
, BILL_LABOR_RAW_COST
, BILL_LABOR_BRDN_COST
, BILL_LABOR_HRS
, EQUIPMENT_RAW_COST
, EQUIPMENT_BRDN_COST
, CAPITALIZABLE_RAW_COST
, CAPITALIZABLE_BRDN_COST
, LABOR_RAW_COST
, LABOR_BRDN_COST
, LABOR_HRS
, LABOR_REVENUE
, EQUIPMENT_HOURS
, BILLABLE_EQUIPMENT_HOURS
, SUP_INV_COMMITTED_COST
, PO_COMMITTED_COST
, PR_COMMITTED_COST
, OTH_COMMITTED_COST
, ACT_LABOR_HRS
, ACT_EQUIP_HRS
, ACT_LABOR_BRDN_COST
, ACT_EQUIP_BRDN_COST
, ACT_BRDN_COST
, ACT_RAW_COST
, ACT_REVENUE
, ETC_LABOR_HRS
, ETC_EQUIP_HRS
, ETC_LABOR_BRDN_COST
, ETC_EQUIP_BRDN_COST
, ETC_BRDN_COST
, ETC_RAW_COST
, ACT_LABOR_RAW_COST
, ACT_EQUIP_RAW_COST
, ETC_LABOR_RAW_COST
, ETC_EQUIP_RAW_COST
FROM PA.PA_PJT_FACT_PERIOD;
PA.PA_PJT_FACT_PERIOD does not reference any database object
PA.PA_PJT_FACT_PERIOD is referenced by following:
|
|
|