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

VIEW: APPS.PMI_REP_TOP_10_PROD_INGRD_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_ID VARCHAR2 (4)
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
ITEM_ID NUMBER (10) Yes
UOM VARCHAR2 (4)
QTY_PRODUCED NUMBER

Yield Quantity in PMI Global UOM
PROD_VALUE NUMBER

Yield Value
QTY_CONSUMED NUMBER

Consumed Ingredient Quantity in PMI Global UOM
INGD_VALUE 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
,      ITEM_ID
,      UOM
,      QTY_PRODUCED
,      PROD_VALUE
,      QTY_CONSUMED
,      INGD_VALUE
FROM APPS.PMI_REP_TOP_10_PROD_INGRD_V;

Dependencies

[top of page]

APPS.PMI_REP_TOP_10_PROD_INGRD_V references the following:

SchemaAPPS
SynonymGL_PLCY_MST
SynonymIC_ITEM_MST
ViewPMI_GL_TIME_V
SynonymPMI_PROD_SUM
PL/SQL PackagePMI_SECURITY_PKG - show dependent code

APPS.PMI_REP_TOP_10_PROD_INGRD_V is not referenced by any database object