VIEW: APPS.MSC_ALLOCATION_LINES_V

Source

View Text - Preformatted

SELECT mal.rowid, mal.plan_id , mal.inventory_item_id, mal.allocation_qty, nvl(md.order_number, msc_get_name.demand_order_number(md.plan_id, md.sr_instance_id, md.demand_id)), nvl(ms.order_number, to_char(ms.transaction_id)), mal.demand_id, ms.transaction_id, mi.item_name, mal.priority, md.USING_REQUIREMENT_QUANTITY, md.USING_ASSEMBLY_DEMAND_DATE, mal.SUPPLY_DATE, ms.new_dock_date, mal.shipment_id, mal.max_late_date, mal.max_early_date, mal.LAST_UPDATE_DATE , mal.LAST_UPDATED_BY , mal.CREATION_DATE , mal.CREATED_BY , mal.LAST_UPDATE_LOGIN FROM msc_allocation_lines mal, msc_demands md, msc_supplies ms, msc_items mi WHERE mi.inventory_item_id = mal.inventory_item_ID AND mal.plan_id = md.plan_id AND mal.demand_id = md.demand_id AND mal.plan_id = ms.plan_id AND mal.inventory_item_id = ms.inventory_item_id AND mal.shipment_id = ms.shipment_id

View Text - HTML Formatted

SELECT MAL.ROWID
, MAL.PLAN_ID
, MAL.INVENTORY_ITEM_ID
, MAL.ALLOCATION_QTY
, NVL(MD.ORDER_NUMBER
, MSC_GET_NAME.DEMAND_ORDER_NUMBER(MD.PLAN_ID
, MD.SR_INSTANCE_ID
, MD.DEMAND_ID))
, NVL(MS.ORDER_NUMBER
, TO_CHAR(MS.TRANSACTION_ID))
, MAL.DEMAND_ID
, MS.TRANSACTION_ID
, MI.ITEM_NAME
, MAL.PRIORITY
, MD.USING_REQUIREMENT_QUANTITY
, MD.USING_ASSEMBLY_DEMAND_DATE
, MAL.SUPPLY_DATE
, MS.NEW_DOCK_DATE
, MAL.SHIPMENT_ID
, MAL.MAX_LATE_DATE
, MAL.MAX_EARLY_DATE
, MAL.LAST_UPDATE_DATE
, MAL.LAST_UPDATED_BY
, MAL.CREATION_DATE
, MAL.CREATED_BY
, MAL.LAST_UPDATE_LOGIN
FROM MSC_ALLOCATION_LINES MAL
, MSC_DEMANDS MD
, MSC_SUPPLIES MS
, MSC_ITEMS MI
WHERE MI.INVENTORY_ITEM_ID = MAL.INVENTORY_ITEM_ID
AND MAL.PLAN_ID = MD.PLAN_ID
AND MAL.DEMAND_ID = MD.DEMAND_ID
AND MAL.PLAN_ID = MS.PLAN_ID
AND MAL.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID
AND MAL.SHIPMENT_ID = MS.SHIPMENT_ID