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

VIEW: APPS.PMI_INV_CALENDAR_V

Object Details
Object Name: PMI_INV_CALENDAR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMI_INV_CALENDAR_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Inventory Calendar View


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGN_CODE VARCHAR2 (4) Yes Organization Code
FISCAL_YEAR VARCHAR2 (4) Yes Fiscal Year from GL calendar
PERIOD_ID NUMBER (10) Yes Period ID
PERIOD NUMBER (5) Yes Period from GL calendar
CALENDAR_DESC VARCHAR2 (40) Yes Calendar
CLOSED_YEAR_IND NUMBER (5) Yes ClosedYear Indicator
CURRENT_YEAR_IND NUMBER (5) Yes Current Year Indicator
CLOSED_PERIOD_IND NUMBER (5) Yes Closed Period Indicator
CURRENT_PERIOD_IND NUMBER (5) Yes Current Period Indicator
PERIOD_TYPE NUMBER (5) Yes Period Type can have Year/Quarter/Period as value
PERIOD_DESC VARCHAR2 (40) Yes Period Description
END_DATE DATE
Yes End Date for the period type
START_DATE DATE

Start Date for the period type
CREATION_DATE DATE
Yes Creation date
LAST_UPDATE_DATE DATE
Yes Last Updated date
Query Text

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


SELECT ORGN_CODE
,      FISCAL_YEAR
,      PERIOD_ID
,      PERIOD
,      CALENDAR_DESC
,      CLOSED_YEAR_IND
,      CURRENT_YEAR_IND
,      CLOSED_PERIOD_IND
,      CURRENT_PERIOD_IND
,      PERIOD_TYPE
,      PERIOD_DESC
,      END_DATE
,      START_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPS.PMI_INV_CALENDAR_V;

Dependencies

[top of page]

APPS.PMI_INV_CALENDAR_V references the following:

SchemaAPPS
SynonymIC_CLDR_DTL
SynonymIC_CLDR_HDR
APPS.PMI_INV_CALENDAR_V is referenced by following:

SchemaAPPS
ViewPMIFV_INVENTORY_TRANSACTIONS_V
ViewPMIFV_PERIODINVENTORY_V
Package BodyPMI_COST_ANALZ_PACK - show dependent code