[Home] [Help] [Dependency Information]
Object Name: | PJI_ORG_EXTR_INFO# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | ||
PF_CURRENCY_CODE | VARCHAR2 | (30) | ||
EN_CALENDAR_MIN_DATE | NUMBER | |||
EN_CALENDAR_MAX_DATE | NUMBER | |||
GL_CALENDAR_ID | NUMBER | (15) | ||
GL_CALENDAR_MIN_DATE | NUMBER | |||
GL_CALENDAR_MAX_DATE | NUMBER | |||
PA_CALENDAR_ID | NUMBER | (15) | ||
PA_CALENDAR_MIN_DATE | NUMBER | |||
PA_CALENDAR_MAX_DATE | NUMBER | |||
PROJFUNC_CURRENCY_MAU | NUMBER | |||
PA_FIRST_PERIOD_ID | NUMBER | |||
PA_FIRST_PERIOD_NAME | VARCHAR2 | (100) | ||
PA_FIRST_START_DATE | NUMBER | |||
PA_FIRST_END_DATE | NUMBER | |||
GL_FIRST_PERIOD_ID | NUMBER | |||
GL_FIRST_PERIOD_NAME | VARCHAR2 | (100) | ||
GL_FIRST_START_DATE | NUMBER | |||
GL_FIRST_END_DATE | NUMBER | |||
PA_CURR_REP_PERIOD | VARCHAR2 | (15) | ||
GL_CURR_REP_PERIOD | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, PF_CURRENCY_CODE
, EN_CALENDAR_MIN_DATE
, EN_CALENDAR_MAX_DATE
, GL_CALENDAR_ID
, GL_CALENDAR_MIN_DATE
, GL_CALENDAR_MAX_DATE
, PA_CALENDAR_ID
, PA_CALENDAR_MIN_DATE
, PA_CALENDAR_MAX_DATE
, PROJFUNC_CURRENCY_MAU
, PA_FIRST_PERIOD_ID
, PA_FIRST_PERIOD_NAME
, PA_FIRST_START_DATE
, PA_FIRST_END_DATE
, GL_FIRST_PERIOD_ID
, GL_FIRST_PERIOD_NAME
, GL_FIRST_START_DATE
, GL_FIRST_END_DATE
, PA_CURR_REP_PERIOD
, GL_CURR_REP_PERIOD
FROM PJI.PJI_ORG_EXTR_INFO#;
|
|
|