[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_EXTR_PLAN |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_EXTR_PLAN |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_TYPE | VARCHAR2 | (4) | Yes | |
CALENDAR_TYPE_CODE | VARCHAR2 | (10) | Yes | |
WORKER_ID | NUMBER | |||
BATCH_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
PROJECT_ORG_ID | NUMBER | |||
PF_CURRENCY_CODE | VARCHAR2 | (30) | ||
VERSION_ID | NUMBER | |||
PLAN_TYPE_CODE | VARCHAR2 | (30) | ||
CURRENCY_TYPE | VARCHAR2 | (1) | ||
PERIOD_ID | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (100) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
REVENUE | NUMBER | |||
RAW_COST | NUMBER | |||
BURDENED_COST | NUMBER | |||
LABOR_HRS | NUMBER | |||
TIME_DANGLING_FLAG | VARCHAR2 | (4) | ||
RATE_DANGLING_FLAG | VARCHAR2 | (4) | ||
RATE2_DANGLING_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_TYPE
, CALENDAR_TYPE_CODE
, WORKER_ID
, BATCH_ID
, PROJECT_ID
, PROJECT_ORG_ID
, PF_CURRENCY_CODE
, VERSION_ID
, PLAN_TYPE_CODE
, CURRENCY_TYPE
, PERIOD_ID
, PERIOD_NAME
, START_DATE
, END_DATE
, REVENUE
, RAW_COST
, BURDENED_COST
, LABOR_HRS
, TIME_DANGLING_FLAG
, RATE_DANGLING_FLAG
, RATE2_DANGLING_FLAG
FROM PJI.PJI_FM_EXTR_PLAN;
PJI.PJI_FM_EXTR_PLAN does not reference any database object
PJI.PJI_FM_EXTR_PLAN is referenced by following:
|
|
|