[Home] [Help]
View: PMIFV_BATCH_STATUS_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | Batch Status |
Implementation/DBA Data: |
APPS.PMIFV_BATCH_STATUS_V
|
View Text
SELECT BTCHSTS.CO_CODE
, BTCHSTS.PLANT_CODE
, BTCHSTS.WHSE_CODE
, BTCHSTS.FISCAL_YEAR
, BTCHSTS.PERIOD_NUM
, BTCHSTS.PERIOD_NAME
, BTCHSTS.ITEM_ID
, ITEMMST.ITEM_NO
, ITEMMST.ITEM_DESC1
, ITEMMST.PLANNING_CLASS
, BTCHSTS.BATCH_STATUS_CODE
, LOOKUPS.MEANING
, BTCHSTS.BATCH_COUNT
, BTCHSTS.LAST_UPDATE_DATE
FROM PMI_BATCH_STATUS BTCHSTS
, IC_ITEM_MST ITEMMST
, GEM_LOOKUPS LOOKUPS
WHERE BTCHSTS.ITEM_ID = ITEMMST.ITEM_ID
AND BTCHSTS.BATCH_STATUS_CODE = LOOKUPS.LOOKUP_CODE
AND LOOKUPS.LOOKUP_TYPE = 'PMI_BATCH_STATUS'
AND (BTCHSTS.PLANT_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY
Columns
Name |
CO_CODE |
PLANT_CODE |
WHSE_CODE |
FISCAL_YEAR |
PERIOD_NUM |
PERIOD_NAME |
ITEM_ID |
ITEM_NO |
ITEM_DESC |
PLANNING_CLASS |
BATCH_STATUS_CODE |
BATCH_STATUS |
BATCH_COUNT |
LAST_UPDATE_DATE |