VIEW: APPS.MTL_DEMAND_V

Source

View Text - Preformatted

SELECT M.ROWID ROW_ID , M.DEMAND_ID , M.ORGANIZATION_ID , M.INVENTORY_ITEM_ID , MSIK.PADDED_CONCATENATED_SEGMENTS ITEM , MSIK.DESCRIPTION ITEM_DESCRIPTION , MSIK.REVISION_QTY_CONTROL_CODE REVISION_CONTROL , MSIK.LOT_CONTROL_CODE LOT_CONTROL , MSIK.LOCATION_CONTROL_CODE ITEM_LOCATION_CONTROL_CODE , MSIK.PRIMARY_UOM_CODE PRIMARY_UOM , MSIK.SHELF_LIFE_CODE SHELF_LIFE_CODE , M.DEMAND_SOURCE_TYPE , M.DEMAND_SOURCE_HEADER_ID , M.DEMAND_SOURCE_LINE , M.DEMAND_SOURCE_NAME , M.PARENT_DEMAND_ID , M.UOM_CODE UOM , M.LINE_ITEM_QUANTITY ORIG_LINE_QTY , M.PRIMARY_UOM_QUANTITY PUOM_ORIG_RSV_QTY , M.COMPLETED_QUANTITY PUOM_ISSUED_QTY , (M.PRIMARY_UOM_QUANTITY-M.COMPLETED_QUANTITY) PUOM_REMAINING_QTY , M.REQUIREMENT_DATE REQ_DATE , M.LAST_UPDATE_DATE , M.LAST_UPDATED_BY , M.CREATION_DATE , M.CREATED_BY , M.LAST_UPDATE_LOGIN , M.USER_LINE_NUM , M.REVISION , M.LOT_NUMBER , M.SUBINVENTORY , M.LOCATOR_ID , M.ATTRIBUTE_CATEGORY , M.ATTRIBUTE1 , M.ATTRIBUTE2 , M.ATTRIBUTE3 , M.ATTRIBUTE4 , M.ATTRIBUTE5 , M.ATTRIBUTE6 , M.ATTRIBUTE7 , M.ATTRIBUTE8 , M.ATTRIBUTE9 , M.ATTRIBUTE10 , M.ATTRIBUTE11 , M.ATTRIBUTE12 , M.ATTRIBUTE13 , M.ATTRIBUTE14 , M.ATTRIBUTE15 FROM MTL_DEMAND M, MTL_SYSTEM_ITEMS_KFV MSIK WHERE M.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND M.ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND M.RESERVATION_TYPE = 2 AND M.PARENT_DEMAND_ID IS NOT NULL AND M.PRIMARY_UOM_QUANTITY > M.COMPLETED_QUANTITY

View Text - HTML Formatted

SELECT M.ROWID ROW_ID
, M.DEMAND_ID
, M.ORGANIZATION_ID
, M.INVENTORY_ITEM_ID
, MSIK.PADDED_CONCATENATED_SEGMENTS ITEM
, MSIK.DESCRIPTION ITEM_DESCRIPTION
, MSIK.REVISION_QTY_CONTROL_CODE REVISION_CONTROL
, MSIK.LOT_CONTROL_CODE LOT_CONTROL
, MSIK.LOCATION_CONTROL_CODE ITEM_LOCATION_CONTROL_CODE
, MSIK.PRIMARY_UOM_CODE PRIMARY_UOM
, MSIK.SHELF_LIFE_CODE SHELF_LIFE_CODE
, M.DEMAND_SOURCE_TYPE
, M.DEMAND_SOURCE_HEADER_ID
, M.DEMAND_SOURCE_LINE
, M.DEMAND_SOURCE_NAME
, M.PARENT_DEMAND_ID
, M.UOM_CODE UOM
, M.LINE_ITEM_QUANTITY ORIG_LINE_QTY
, M.PRIMARY_UOM_QUANTITY PUOM_ORIG_RSV_QTY
, M.COMPLETED_QUANTITY PUOM_ISSUED_QTY
, (M.PRIMARY_UOM_QUANTITY-M.COMPLETED_QUANTITY) PUOM_REMAINING_QTY
, M.REQUIREMENT_DATE REQ_DATE
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.USER_LINE_NUM
, M.REVISION
, M.LOT_NUMBER
, M.SUBINVENTORY
, M.LOCATOR_ID
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
FROM MTL_DEMAND M
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE M.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND M.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND M.RESERVATION_TYPE = 2
AND M.PARENT_DEMAND_ID IS NOT NULL
AND M.PRIMARY_UOM_QUANTITY > M.COMPLETED_QUANTITY