[Home] [Help]
View: OPI_EDW_EXP_INV_VAL_PERD_V
Product: | OPI - Operations Intelligence (Obsolete) |
Description: | Expired Inventory Value report source view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT INV.ALL_PK_KEY ALL_LOCATORS_ID
, INV.PCMP_OPM_COMPANY_PK_KEY PCMP_ID
, INV.PORG_OPM_ORGANIZATION_PK_KEY PORG_ID
, INV.OU_OPERATING_UNIT_PK_KEY OPERATING_UNIT_ID
, INV.PLNT_PLANT_PK_KEY PLANT_ID
, INV.SUBI_STOCK_ROOM_PK_KEY SUB_INV_ID
, TIME.CPER_CAL_PERIOD_PK_KEY CAL_PERIOD_ID
, IT.ALL_ALL_PK_KEY ALL_ITEMS_ID
, IT.CO16_CATEGORY_PK_KEY ITEM_CAT_ID
, IT.IREV_ITEM_REVISION_PK_KEY ITEM_ID
, LOT.LOT_EXPIRATION_DATE EXPDATE
, NVL(IPS.END_ONH_VAL_G
, 0) EONH_INV
, DECODE(SIGN(LOT.LOT_EXPIRATION_DATE - TIME.CPER_END_DATE)
, -1
, NVL(IPS.END_ONH_VAL_G
, 0)
, 0) EXPONH_INV
, NVL(IPS.END_INT_VAL_G
, 0) EINT_INV
, NVL(IPS.END_WIP_VAL_G
, 0) EWIP_INV
FROM OPI_EDW_INV_PERD_STAT_F IPS
, EDW_MTL_INVENTORY_LOC_M INV
, EDW_ITEMS_M IT
, EDW_TIME_M TIME
, EDW_OPI_LOT_M LOT
WHERE INV.INVL_LOCATOR_PK_KEY = IPS.LOCATOR_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = IPS.PRD_DATE_FK_KEY
AND IT.IREV_ITEM_REVISION_PK_KEY = IPS.ITEM_ORG_FK_KEY
AND LOT.LOT_EDW_LOT_PK_KEY = IPS.LOT_FK_KEY --
AND LOT.LOT_EXPIRATION_DATE < SYSDATE
Columns
Name |
ALL_LOCATORS_ID |
PCMP_ID |
PORG_ID |
OPERATING_UNIT_ID |
PLANT_ID |
SUB_INV_ID |
CAL_PERIOD_ID |
ALL_ITEMS_ID |
ITEM_CAT_ID |
ITEM_ID |
EXPDATE |
EONH_INV |
EXPONH_INV |
EINT_INV |
EWIP_INV |