[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_REXT_ERDL |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FM_REXT_ERDL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 0 |
PCT Used: |
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 |
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;
PJI.PJI_FM_REXT_ERDL does not reference any database object
PJI.PJI_FM_REXT_ERDL is referenced by following:
|
|
|