DBA Data[Home] [Help]

VIEW: APPS.PMI_REP_PROD_YLD_VARANCE_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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