VIEW: APPS.WSM_RESERVATIONS_V

Source

View Text - Preformatted

SELECT mr.rowid row_id, mr.RESERVATION_ID, mr.ORGANIZATION_ID, mr.DEMAND_SOURCE_TYPE_ID, mr.DEMAND_SOURCE_NAME, mr.DEMAND_SOURCE_HEADER_ID, mr.DEMAND_SOURCE_LINE_ID, ool.line_number || '.'|| ool.shipment_number || DECODE(ool.option_number, NULL , '' , '.' || ool.option_number ) DEMAND_SOURCE_LINE_NUMBER, ott.TRANSACTION_TYPE_CODE order_type, hzc.account_number CUSTOMER_NUMBER, hzp.party_name CUSTOMER_NAME, ool.DEMAND_CLASS_CODE, mr.REQUIREMENT_DATE, mr.INVENTORY_ITEM_ID, mr.revision ITEM_REVISION, mr.SUBINVENTORY_CODE, mr.LOCATOR_ID, mr.LOT_NUMBER, mr.SERIAL_NUMBER, mr.PRIMARY_UOM_CODE, mr.PRIMARY_RESERVATION_QUANTITY PRIMARY_QUANTITY, mr.RESERVATION_UOM_CODE, mr.RESERVATION_QUANTITY, ool.order_quantity_uom, mr.SUPPLY_SOURCE_HEADER_ID WIP_ENTITY_ID, mr.LAST_UPDATE_DATE, mr.LAST_UPDATED_BY, mr.CREATION_DATE, mr.CREATED_BY, mr.LAST_UPDATE_LOGIN, mr.REQUEST_ID, mr.PROGRAM_APPLICATION_ID, mr.PROGRAM_ID, mr.PROGRAM_UPDATE_DATE FROM mtl_reservations mr, oe_order_lines_all ool, oe_transaction_types_all ott, mtl_sales_orders mso, hz_parties hzp, hz_cust_accounts hzc WHERE ool.line_type_id = ott.transaction_type_id and mso.sales_order_id = mr.demand_source_header_id and mr.demand_source_line_id = ool.line_id and mr.demand_source_type_id in ( 2,8) and mr.supply_source_type_id = 5 and ool.sold_to_org_id = hzc.cust_account_id and hzp.party_id = hzc.party_id

View Text - HTML Formatted

SELECT MR.ROWID ROW_ID
, MR.RESERVATION_ID
, MR.ORGANIZATION_ID
, MR.DEMAND_SOURCE_TYPE_ID
, MR.DEMAND_SOURCE_NAME
, MR.DEMAND_SOURCE_HEADER_ID
, MR.DEMAND_SOURCE_LINE_ID
, OOL.LINE_NUMBER || '.'|| OOL.SHIPMENT_NUMBER || DECODE(OOL.OPTION_NUMBER
, NULL
, ''
, '.' || OOL.OPTION_NUMBER ) DEMAND_SOURCE_LINE_NUMBER
, OTT.TRANSACTION_TYPE_CODE ORDER_TYPE
, HZC.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HZP.PARTY_NAME CUSTOMER_NAME
, OOL.DEMAND_CLASS_CODE
, MR.REQUIREMENT_DATE
, MR.INVENTORY_ITEM_ID
, MR.REVISION ITEM_REVISION
, MR.SUBINVENTORY_CODE
, MR.LOCATOR_ID
, MR.LOT_NUMBER
, MR.SERIAL_NUMBER
, MR.PRIMARY_UOM_CODE
, MR.PRIMARY_RESERVATION_QUANTITY PRIMARY_QUANTITY
, MR.RESERVATION_UOM_CODE
, MR.RESERVATION_QUANTITY
, OOL.ORDER_QUANTITY_UOM
, MR.SUPPLY_SOURCE_HEADER_ID WIP_ENTITY_ID
, MR.LAST_UPDATE_DATE
, MR.LAST_UPDATED_BY
, MR.CREATION_DATE
, MR.CREATED_BY
, MR.LAST_UPDATE_LOGIN
, MR.REQUEST_ID
, MR.PROGRAM_APPLICATION_ID
, MR.PROGRAM_ID
, MR.PROGRAM_UPDATE_DATE
FROM MTL_RESERVATIONS MR
, OE_ORDER_LINES_ALL OOL
, OE_TRANSACTION_TYPES_ALL OTT
, MTL_SALES_ORDERS MSO
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZC
WHERE OOL.LINE_TYPE_ID = OTT.TRANSACTION_TYPE_ID
AND MSO.SALES_ORDER_ID = MR.DEMAND_SOURCE_HEADER_ID
AND MR.DEMAND_SOURCE_LINE_ID = OOL.LINE_ID
AND MR.DEMAND_SOURCE_TYPE_ID IN ( 2
, 8)
AND MR.SUPPLY_SOURCE_TYPE_ID = 5
AND OOL.SOLD_TO_ORG_ID = HZC.CUST_ACCOUNT_ID
AND HZP.PARTY_ID = HZC.PARTY_ID