MSC_AP_MTRL_ONHAND_SUP_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
LINE_ID ORGANIZATION_ID ORGANIZATION_CODE INVENTORY_ITEM_ID ITEM_NUMBER SUBINVENTORY_CODE LOT_NUMBER QUANTITY EXPIRATION_DATE

Query

SQL_Statement

SELECT /*+ leading(mtrl) */ mtrl.line_id , mtrl.Organization_ID , esi.Organization_code , mtrl.Inventory_Item_ID , esi.item_number , TO_CHAR(NULL) Subinventory_Code , TO_CHAR(NULL) Lot_Number , mtrl.Primary_Quantity Quantity , TO_DATE(NULL) Expiration_Date FROM MSC_PLANNED_EGP_SYSTEM_ITEMS_V esi , INV_TXN_REQUEST_LINES mtrl, INV_TXN_REQUEST_HEADERS mtrh, INV_TRANSACTION_TYPES mtt WHERE esi.Organization_ID = mtrl.Organization_ID AND esi.Inventory_Item_ID = mtrl.Inventory_Item_ID AND mtrh.HEADER_ID = mtrl.HEADER_ID AND mtrh.MOVE_ORDER_TYPE = 6 AND mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID = 31