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_LATE_BATCHES_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY_ID	VARCHAR2	(4)	Yes	Key to map Process Manufacturing Company PMF Dimension Value
ORGANIZATION_ID	VARCHAR2	(4)	Yes	Key to map Process Manufacturing Organization PMF Dimension Value
YEAR_ID	VARCHAR2	(31)		Key to map Year Level PMF Time Dimension Value
QUARTER_ID	VARCHAR2	(31)		Key to map Quarter Level PMF Time Dimension Value
PERIOD_ID	VARCHAR2	(31)		Key to map Period Level PMF Time Dimension Value
TOT_NO_BTCHS	NUMBER			This column will have 1 as its value
LATE_BTCHS	NUMBER			This column will have 1 as its value batch is late

Query Text

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


SELECT COMPANY_ID
,      ORGANIZATION_ID
,      YEAR_ID
,      QUARTER_ID
,      PERIOD_ID
,      TOT_NO_BTCHS
,      LATE_BTCHS
FROM APPS.PMI_REP_LATE_BATCHES_V;

Dependencies

[top of page]

APPS.PMI_REP_LATE_BATCHES_V references the following:

APPS: FND_PROFILE - show dependent code; GL_PLCY_MST; GME_BATCH_HEADER; PMI_GL_TIME_V; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMI_REP_LATE_BATCHES_V is not referenced by any database object