VIEW: APPS.OPI_EDW_INV_QTY_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, inv.INVL_LOCATOR_PK_KEY LOCATOR_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, uom.UOM_EDW_UOM_PK_KEY UOM_ID, nvl(ips.END_ONH_QTY,0) EONH_INV_QTY FROM OPI_EDW_INV_PERD_STAT_F ips, EDW_MTL_INVENTORY_LOC_M inv, EDW_ITEMS_M it, EDW_TIME_M time, EDW_MTL_UOM_M uom 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 uom.UOM_EDW_UOM_PK_KEY = ips.BASE_UOM_FK_KEY

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
, INV.INVL_LOCATOR_PK_KEY LOCATOR_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
, UOM.UOM_EDW_UOM_PK_KEY UOM_ID
, NVL(IPS.END_ONH_QTY
, 0) EONH_INV_QTY
FROM OPI_EDW_INV_PERD_STAT_F IPS
, EDW_MTL_INVENTORY_LOC_M INV
, EDW_ITEMS_M IT
, EDW_TIME_M TIME
, EDW_MTL_UOM_M UOM
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 UOM.UOM_EDW_UOM_PK_KEY = IPS.BASE_UOM_FK_KEY