FND Design Data [Home] [Help]

View: PMI_REP_PROD_YLD_VARANCE_V

Product: PMI - Process Manufacturing Intelligence (Obsolete)
Description: This is view for PMI Production Usage Variance Report
Implementation/DBA Data: ViewAPPS.PMI_REP_PROD_YLD_VARANCE_V
View Text

SELECT COMPANY_ID
, ORGANIZATION_ID
, YEAR_ID
, QUARTER_ID
, PERIOD_ID
, ACTUAL_QTY
, PLAN_QTY
FROM PMI_REP_PROD_ACTUAL_PLAN_V
WHERE LINE_TYPE = 1

Columns

Name
COMPANY_ID
ORGANIZATION_ID
YEAR_ID
QUARTER_ID
PERIOD_ID
ACTUAL_QTY
PLAN_QTY