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.PMI_REP_PROD_USG_VARANCE_V

Object Details

Object Name:	PMI_REP_PROD_USG_VARANCE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMI_REP_PROD_USG_VARANCE_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PMI Product Usage Variance Report view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY_ID	VARCHAR2	(4)	Yes	OPM Company Code
ORGANIZATION_ID	VARCHAR2	(4)	Yes	OPM Organization Code
YEAR_ID	VARCHAR2	(31)		Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year
QUARTER_ID	VARCHAR2	(31)		Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter
PERIOD_ID	VARCHAR2	(31)		Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period
ACTUAL_QTY	NUMBER
PLAN_QTY	NUMBER

Query Text

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


SELECT COMPANY_ID
,      ORGANIZATION_ID
,      YEAR_ID
,      QUARTER_ID
,      PERIOD_ID
,      ACTUAL_QTY
,      PLAN_QTY
FROM APPS.PMI_REP_PROD_USG_VARANCE_V;

Dependencies

[top of page]

APPS.PMI_REP_PROD_USG_VARANCE_V references the following:

APPS: FND_PROFILE - show dependent code; GMICUOM - show dependent code; PMI_REP_PROD_ACTUAL_PLAN_V; PMI_SECURITY_PKG - show dependent code

APPS.PMI_REP_PROD_USG_VARANCE_V is not referenced by any database object