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

VIEW: APPS.ISC_MSC_BIS_QUARTERS_V

Object Details
Object Name: ISC_MSC_BIS_QUARTERS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view stores quarters between the calendar start date and end dates.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (163)
Source application instance identifier||'-'||Organization identifier||'-'||Accounting period year||'-'||Quarter number of accounting period
VALUE VARCHAR2 (90)
'Quarter '||Quarter number of accounting period||', '||Accounting period year
PERIOD_SET_NAME CHAR (10)
Accounting calendar name
PERIOD_NAME VARCHAR2 (84)
'QTR '||Quarter number of accounting period||Accounting period year
START_DATE DATE

Date on which the quarter containing this accounting period starts
END_DATE DATE

Date on which the quarter containing this accounting period ends
PERIOD_YEAR NUMBER (15) Yes Accounting period year
ORGANIZATION_ID VARCHAR2 (81)
Source application instance identifier||'-'||Organization identifier
ORGANIZATION_TYPE CHAR (12)
Organization type
Query Text

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


SELECT ID
,      VALUE
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      PERIOD_YEAR
,      ORGANIZATION_ID
,      ORGANIZATION_TYPE
FROM APPS.ISC_MSC_BIS_QUARTERS_V;

Dependencies

[top of page]

APPS.ISC_MSC_BIS_QUARTERS_V references the following:

SchemaAPPS
SynonymMSC_BIS_PERIODS
APPS.ISC_MSC_BIS_QUARTERS_V is referenced by following:

SchemaAPPS
ViewISC_MSC_MFG_MEASURES_V
ViewISC_MSC_PURCHASING_V
ViewISC_MSC_SERVICE_LEVELS_V