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

TABLE: PJI.PJI_FM_EXTR_PLN

Object Details
Object Name: PJI_FM_EXTR_PLN
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FM_EXTR_PLN
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
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

Query Text

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;

Dependencies

[top of page]

PJI.PJI_FM_EXTR_PLN does not reference any database object

PJI.PJI_FM_EXTR_PLN is referenced by following:

SchemaAPPS
SynonymPJI_FM_EXTR_PLN