[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: |
APPS.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 |