[Home] [Help]
View: PMI_REP_PROD_YLD_VARANCE_V
| Product: | PMI - Process Manufacturing Intelligence |
| Description: | This is view for PMI Production Usage Variance Report |
| Implementation/DBA Data: |
APPS.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 |