VIEW: APPS.CSL_MTL_ONHAND_QTY_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.LAST_UPDATE_DATE , B.TOT_TXN_QUANTITY , B.SUBINVENTORY_CODE , B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , B.REVISION , B.LOCATOR_ID , B.LOT_NUMBER FROM CSL_MTL_ONHAND_QTY_MV B , CSL_MTL_ONHAND_QTY_ACC ACC WHERE ACC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ACC.ORGANIZATION_ID = B.ORGANIZATION_ID AND ACC.SUBINVENTORY_CODE = B.SUBINVENTORY_CODE AND ((ACC.REVISION = B.REVISION) OR (ACC.REVISION IS NULL AND B.REVISION IS NULL)) AND ((ACC.LOCATOR_ID = B.LOCATOR_ID) OR (ACC.LOCATOR_ID IS NULL AND B.LOCATOR_ID IS NULL)) AND ((ACC.LOT_NUMBER = B.LOT_NUMBER) OR (ACC.LOT_NUMBER IS NULL AND B.LOT_NUMBER IS NULL)) AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.LAST_UPDATE_DATE
, B.TOT_TXN_QUANTITY
, B.SUBINVENTORY_CODE
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.REVISION
, B.LOCATOR_ID
, B.LOT_NUMBER
FROM CSL_MTL_ONHAND_QTY_MV B
, CSL_MTL_ONHAND_QTY_ACC ACC
WHERE ACC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND ACC.ORGANIZATION_ID = B.ORGANIZATION_ID
AND ACC.SUBINVENTORY_CODE = B.SUBINVENTORY_CODE
AND ((ACC.REVISION = B.REVISION) OR (ACC.REVISION IS NULL
AND B.REVISION IS NULL))
AND ((ACC.LOCATOR_ID = B.LOCATOR_ID) OR (ACC.LOCATOR_ID IS NULL
AND B.LOCATOR_ID IS NULL))
AND ((ACC.LOT_NUMBER = B.LOT_NUMBER) OR (ACC.LOT_NUMBER IS NULL
AND B.LOT_NUMBER IS NULL))
AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID