[Home] [Help]
[Dependency Information]
VIEW: APPS.PMI_GL_CALENDAR_V
Object Details
Object Name: | PMI_GL_CALENDAR_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMI_GL_CALENDAR_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CO_CODE |
VARCHAR2 |
(4) |
Yes |
|
PERIOD_TYPE |
VARCHAR2 |
(15) |
Yes |
|
PERIOD_YEAR |
NUMBER |
(15) |
Yes |
|
QUARTER_NUM |
NUMBER |
(15) |
Yes |
|
PERIOD_NUM |
NUMBER |
(15) |
Yes |
|
PERIOD_NAME |
VARCHAR2 |
(15) |
Yes |
|
START_DATE |
DATE |
|
Yes |
|
END_DATE |
DATE |
|
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CO_CODE
, PERIOD_TYPE
, PERIOD_YEAR
, QUARTER_NUM
, PERIOD_NUM
, PERIOD_NAME
, START_DATE
, END_DATE
FROM APPS.PMI_GL_CALENDAR_V;
Dependencies
[top of page]
APPS.PMI_GL_CALENDAR_V references the following:
-
APPS
-
GL_PERIODS
-
GL_PLCY_MST
-
GL_SETS_OF_BOOKS
APPS.PMI_GL_CALENDAR_V is referenced by following:
-
APPS
-
PMIFV_BATCH_DETAILS_V
-
PMIFV_BATCH_OPRN_DETAIL_V
-
PMIFV_BATCH_QC_V
-
PMIFV_BATCH_TRANS_V
-
PMIFV_BTCH_QCRSLT_V
-
PMIFV_PROD_EFFI_V
-
PMIFV_SALES_DETAILS_V
-
PMI_PRODUCTION_SUM
- show dependent code
-
PMI_SALES_PKG
- show dependent code
-
PMI_SALES_PKG
- show dependent code