View: MTL_RESERVATIONS_ALL_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_RESERVATIONS_ALL_V

View Text

SELECT MR.RESERVATION_ID RESERVATION_ID
, MR.REQUIREMENT_DATE REQUIREMENT_DATE
, MR.ORGANIZATION_ID ORGANIZATION_ID
, MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MR.DEMAND_SOURCE_TYPE_ID DEMAND_SOURCE_TYPE_ID
, MR.DEMAND_SOURCE_NAME DEMAND_SOURCE_NAME
, MR.DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, MR.DEMAND_SOURCE_LINE_ID DEMAND_SOURCE_LINE_ID
, MR.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, MR.PRIMARY_UOM_ID PRIMARY_UOM_ID
, MR.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, MR.SECONDARY_UOM_ID SECONDARY_UOM_ID
, MR.RESERVATION_UOM_CODE RESERVATION_UOM_CODE
, MR.RESERVATION_UOM_ID RESERVATION_UOM_ID
, MR.RESERVATION_QUANTITY RESERVATION_QUANTITY
, MR.PRIMARY_RESERVATION_QUANTITY PRIMARY_RESERVATION_QUANTITY
, MR.SECONDARY_RESERVATION_QUANTITY SECONDARY_RESERVATION_QUANTITY
, MR.AUTODETAIL_GROUP_ID AUTODETAIL_GROUP_ID
, MR.EXTERNAL_SOURCE_CODE EXTERNAL_SOURCE_CODE
, MR.EXTERNAL_SOURCE_LINE_ID EXTERNAL_SOURCE_LINE_ID
, MR.SUPPLY_SOURCE_TYPE_ID SUPPLY_SOURCE_TYPE_ID
, MR.SUPPLY_SOURCE_HEADER_ID SUPPLY_SOURCE_HEADER_ID
, MR.SUPPLY_SOURCE_LINE_ID SUPPLY_SOURCE_LINE_ID
, MR.SUPPLY_SOURCE_LINE_DETAIL SUPPLY_SOURCE_LINE_DETAIL
, MR.SUPPLY_SOURCE_NAME SUPPLY_SOURCE_NAME
, MR.REVISION REVISION
, MR.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MR.SUBINVENTORY_ID SUBINVENTORY_ID
, MR.LOCATOR_ID LOCATOR_ID
, MR.LOT_NUMBER LOT_NUMBER
, MR.LOT_NUMBER_ID LOT_NUMBER_ID
, MR.PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, MR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MR.LAST_UPDATED_BY LAST_UPDATED_BY
, MR.CREATION_DATE CREATION_DATE
, MR.CREATED_BY CREATED_BY
, MR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MR.REQUEST_ID REQUEST_ID
, MR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MR.PROGRAM_ID PROGRAM_ID
, MR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MR.ATTRIBUTE1 ATTRIBUTE1
, MR.ATTRIBUTE2 ATTRIBUTE2
, MR.ATTRIBUTE3 ATTRIBUTE3
, MR.ATTRIBUTE4 ATTRIBUTE4
, MR.ATTRIBUTE5 ATTRIBUTE5
, MR.ATTRIBUTE6 ATTRIBUTE6
, MR.ATTRIBUTE7 ATTRIBUTE7
, MR.ATTRIBUTE8 ATTRIBUTE8
, MR.ATTRIBUTE9 ATTRIBUTE9
, MR.ATTRIBUTE10 ATTRIBUTE10
, MR.ATTRIBUTE11 ATTRIBUTE11
, MR.ATTRIBUTE12 ATTRIBUTE12
, MR.ATTRIBUTE13 ATTRIBUTE13
, MR.ATTRIBUTE14 ATTRIBUTE14
, MR.ATTRIBUTE15 ATTRIBUTE15
, MTST1.TRANSACTION_SOURCE_TYPE_NAME SUPPLY_SOURCE_TYPE
, MTST2.TRANSACTION_SOURCE_TYPE_NAME DEMAND_SOURCE_TYPE
, MR.SHIP_READY_FLAG SHIP_READY_FLAG
, MR.DETAILED_QUANTITY DETAILED_QUANTITY
, MR.SECONDARY_DETAILED_QUANTITY SECONDARY_DETAILED_QUANTITY
, MR.STAGED_FLAG STAGED_FLAG
, MR.LPN_ID
, MLN.GRADE_CODE GRADE_CODE
, NVL(MR.CROSSDOCK_FLAG
, 'N') CROSSDOCK_FLAG
, MR.CROSSDOCK_CRITERIA_ID CROSSDOCK_CRITERIA_ID
, MR.DEMAND_SOURCE_LINE_DETAIL DEMAND_SOURCE_LINE_DETAIL
, MR.SERIAL_RESERVATION_QUANTITY SERIAL_RESERVATION_QUANTITY
, MR.SUPPLY_RECEIPT_DATE SUPPLY_RECEIPT_DATE
, MR.DEMAND_SHIP_DATE DEMAND_SHIP_DATE
, MR.EXCEPTION_CODE EXCEPTION_CODE
, MR.PROJECT_ID PROJECT_ID
, MR.TASK_ID TASK_ID
FROM MTL_RESERVATIONS MR
, MTL_TXN_SOURCE_TYPES MTST1
, MTL_TXN_SOURCE_TYPES MTST2
, MTL_LOT_NUMBERS MLN
WHERE MR.SUPPLY_SOURCE_TYPE_ID = MTST1.TRANSACTION_SOURCE_TYPE_ID (+)
AND MR.DEMAND_SOURCE_TYPE_ID = MTST2.TRANSACTION_SOURCE_TYPE_ID (+)
AND MR.LOT_NUMBER = MLN.LOT_NUMBER(+)
AND MR.ORGANIZATION_ID = MLN.ORGANIZATION_ID(+)
AND MR.INVENTORY_ITEM_ID = MLN.INVENTORY_ITEM_ID(+)

Columns