eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S

Object Details

Object Name:	ISC_EDW_RECEIVE_PAY_CYCLE_S
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ISC.ISC_EDW_RECEIVE_PAY_CYCLE_S
Subobject Name:
Status:	VALID

View Type

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

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the PO Distribution fact table.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
AREA_FK	NUMBER		Foreign key to the Geography dimension, Area level
BUS_GRP_FK	NUMBER		Foreign key to the Internal Organization dimension, Business Group level
CATG_FK	NUMBER		Foreign key to the Item dimension, Category level
COUNTRY_FK	NUMBER		Foreign key to the Geography dimension, Country level
INT_ORGA_FK	NUMBER	Yes	Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK	NUMBER		Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK	NUMBER		Foreign key to the Internal Organization dimension, Operating Unit level
PERIOD_FK	NUMBER		Foreign key to the Time dimension, Period level
QTR_FK	NUMBER		Foreign key to the Time dimension, Quarter level
REGION_FK	NUMBER		Foreign key to the Geography dimension, Region level
TRD_PARTNER_FK	NUMBER		Foreign key to the Trading Partners dimension, Trading Partners level
YEAR_FK	NUMBER		Foreign key to the Time dimension, Year level
RECEIVE_TO_PAY_CYCLE_TIME	NUMBER		Receive to Pay Cycle Time

Query Text

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


SELECT AREA_FK
,      BUS_GRP_FK
,      CATG_FK
,      COUNTRY_FK
,      INT_ORGA_FK
,      LEGAL_ENT_FK
,      OPER_UNIT_FK
,      PERIOD_FK
,      QTR_FK
,      REGION_FK
,      TRD_PARTNER_FK
,      YEAR_FK
,      RECEIVE_TO_PAY_CYCLE_TIME
FROM APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S;

Dependencies

[top of page]

APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S references the following:

APPS: EDW_GEOGRAPHY_M; EDW_ITEMS_M; EDW_ORGANIZATION_M; EDW_TIME_M; EDW_TRD_PARTNER_M; POA_EDW_PO_DIST_F

APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S is not referenced by any database object