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

TABLE: PJI.PJI_FM_REXT_ERDL

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER

ERDL_ROWID ROWID (10)
PROJECT_ORG_ID NUMBER

PROJECT_ORGANIZATION_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

EXP_EVT_TYPE_ID NUMBER

EVENT_TYPE VARCHAR2 (30)
EVENT_NUM NUMBER

REVENUE_CATEGORY VARCHAR2 (30)
EVENT_TYPE_CLASSIFICATION VARCHAR2 (30)
LINE_SOURCE_TYPE VARCHAR2 (1)
BILL_ANOTHER_PROJECT_FLAG VARCHAR2 (1)
CUSTOMER_ID NUMBER

TXN_DATE DATE

PA_DATE DATE

PA_PERIOD_NAME VARCHAR2 (15)
GL_DATE DATE

GL_PERIOD_NAME VARCHAR2 (15)
PROJECT_TYPE_CLASS VARCHAR2 (1)
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Expenditure Organization Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WORKER_ID
,      ERDL_ROWID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      EXP_EVT_TYPE_ID
,      EVENT_TYPE
,      EVENT_NUM
,      REVENUE_CATEGORY
,      EVENT_TYPE_CLASSIFICATION
,      LINE_SOURCE_TYPE
,      BILL_ANOTHER_PROJECT_FLAG
,      CUSTOMER_ID
,      TXN_DATE
,      PA_DATE
,      PA_PERIOD_NAME
,      GL_DATE
,      GL_PERIOD_NAME
,      PROJECT_TYPE_CLASS
,      EXPENDITURE_ORGANIZATION_ID
FROM PJI.PJI_FM_REXT_ERDL;

Dependencies

[top of page]

PJI.PJI_FM_REXT_ERDL does not reference any database object

PJI.PJI_FM_REXT_ERDL is referenced by following:

SchemaPJI
ViewPJI_FM_REXT_ERDL#