VIEW: APPS.MSD_DEM_BEGINING_ONHAND_V

Source

View Text - Preformatted

SELECT plans.plan_id, plans.compile_designator supply_plan, msi.item_name item_code, mtp.organization_code org_code, sup.new_order_quantity quantity, trunc(sup.new_schedule_date) sdate FROM msc_supplies sup, msc_plans plans, msc_system_items msi, msc_trading_partners mtp WHERE sup.plan_id = plans.plan_id and nvl(sup.new_order_quantity,0) !=0 and sup.order_type = 18 and sup.organization_id = msi.organization_id and sup.inventory_item_id = msi.inventory_item_id and sup.plan_id = msi.plan_id and sup.sr_instance_id = msi.sr_instance_id and msi.mrp_planning_code <> 6 and mtp.partner_type = 3 and mtp.sr_instance_id = msi.sr_instance_id and mtp.sr_tp_id = msi.organization_id and nvl(mtp.company_id,-1) = -1 and plans.plan_id <> -1

View Text - HTML Formatted

SELECT PLANS.PLAN_ID
, PLANS.COMPILE_DESIGNATOR SUPPLY_PLAN
, MSI.ITEM_NAME ITEM_CODE
, MTP.ORGANIZATION_CODE ORG_CODE
, SUP.NEW_ORDER_QUANTITY QUANTITY
, TRUNC(SUP.NEW_SCHEDULE_DATE) SDATE
FROM MSC_SUPPLIES SUP
, MSC_PLANS PLANS
, MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
WHERE SUP.PLAN_ID = PLANS.PLAN_ID
AND NVL(SUP.NEW_ORDER_QUANTITY
, 0) !=0
AND SUP.ORDER_TYPE = 18
AND SUP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND SUP.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND SUP.PLAN_ID = MSI.PLAN_ID
AND SUP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSI.MRP_PLANNING_CODE <> 6
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MSI.ORGANIZATION_ID
AND NVL(MTP.COMPANY_ID
, -1) = -1
AND PLANS.PLAN_ID <> -1