[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 |