[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_EXTR_PLN |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_EXTR_PLN |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | (15) | Yes | |
CURRENCY_TYPE | VARCHAR2 | (1) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
PROJECT_ORGANIZATION_ID | NUMBER | (15) | Yes | |
PROJECT_ORG_ID | NUMBER | (15) | Yes | |
PROJECT_TYPE_CLASS | VARCHAR2 | (1) | ||
TIME_PHASED_TYPE_CODE | VARCHAR2 | (1) | ||
PERIOD_NAME | VARCHAR2 | (20) | Yes | |
START_DATE | DATE | Yes | ||
END_DATE | DATE | Yes | ||
PLAN_TYPE_CODE | VARCHAR2 | (30) | Yes | |
CURRENT_FLAG | VARCHAR2 | (1) | ||
CURRENT_ORIGINAL_FLAG | VARCHAR2 | (1) | ||
REVENUE | NUMBER | |||
RAW_COST | NUMBER | |||
BURDENED_COST | NUMBER | |||
LABOR_HRS | NUMBER | |||
CALENDAR_TYPE_CODE | VARCHAR2 | (30) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
TIME_ID | NUMBER | (15) | ||
REVENUE_RATE | NUMBER | |||
REVENUE_EXCHANGE_DATE | DATE | |||
COST_RATE | NUMBER | |||
COST_EXCHANGE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, CURRENCY_TYPE
, PROJECT_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ORG_ID
, PROJECT_TYPE_CLASS
, TIME_PHASED_TYPE_CODE
, PERIOD_NAME
, START_DATE
, END_DATE
, PLAN_TYPE_CODE
, CURRENT_FLAG
, CURRENT_ORIGINAL_FLAG
, REVENUE
, RAW_COST
, BURDENED_COST
, LABOR_HRS
, CALENDAR_TYPE_CODE
, BUDGET_VERSION_ID
, TIME_ID
, REVENUE_RATE
, REVENUE_EXCHANGE_DATE
, COST_RATE
, COST_EXCHANGE_DATE
FROM PJI.PJI_FM_EXTR_PLN;
PJI.PJI_FM_EXTR_PLN does not reference any database object
PJI.PJI_FM_EXTR_PLN is referenced by following:
|
|
|