FND Design Data [Home] [Help]

View: PMI_REP_PROD_USG_VARANCE_V

Product: PMI - Process Manufacturing Intelligence (Obsolete)
Description: PMI Product Usage Variance Report view
Implementation/DBA Data: ViewAPPS.PMI_REP_PROD_USG_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