eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OPI_EDW_EXP_INV_VAL_PERD_V

Source

View Text - Preformatted


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, it.ITEM_ITEM_NUMBER_PK_KEY ITEM_NUMBER_ID, it.IORG_ITEM_ORG_PK_KEY ITEM_ORG_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

View Text - HTML Formatted

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
, IT.ITEM_ITEM_NUMBER_PK_KEY ITEM_NUMBER_ID
, IT.IORG_ITEM_ORG_PK_KEY ITEM_ORG_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