APPS.MSC_ITEM_PKG dependencies on MSC_SUPPLIES

Line 443: from msc_supplies_f

439: and sr_instance_id=c.sr_instance_id and organization_id=c.organization_id
440: union
441: select distinct sr_instance_id, organization_id, inventory_item_id,
442: nvl(vmi_flag, 0) vmi_flag
443: from msc_supplies_f
444: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type=0
445: and sr_instance_id=c.sr_instance_id and organization_id=c.organization_id
446: union
447: select distinct mss.sr_instance_id, mss.organization_id, mss.inventory_item_id,

Line 546: from msc_supplies_f msf

542: msf.organization_id,
543: msf.inventory_item_id,
544: nvl(msf.vmi_flag,0) vmi_flag,
545: msf.supply_date activity_date
546: from msc_supplies_f msf
547: where msf.plan_id = p_plan_id
548: and msf.plan_run_id = p_plan_run_id
549: and msf.aggr_type=0) sd,
550: msc_plans mp

Line 613: from msc_supplies_f msf

609: msf.sr_instance_id,
610: msf.organization_id,
611: msf.inventory_item_id,
612: nvl(msf.vmi_flag,0) vmi_flag
613: from msc_supplies_f msf
614: where msf.plan_id = p_plan_id
615: and msf.plan_run_id = p_plan_run_id
616: and msf.aggr_type=0) sd,
617: msc_plans mp

Line 770: from msc_supplies_f msf,msc_hub_query mfq,msc_plans mps

766: 11,nvl(msf.supply_qty,0),
767: 12,nvl(msf.supply_qty,0),
768: 14,nvl(msf.supply_qty,0), --- bug 6797566 include work oder co/by product
769: 0)) Scheduled_rept_qty
770: from msc_supplies_f msf,msc_hub_query mfq,msc_plans mps
771: where mfq.number1 = msf.plan_id(+)
772: and mfq.number2 = msf.plan_run_id(+)
773: and mfq.number3 = msf.sr_instance_id(+)
774: and mfq.number4 = msf.organization_id(+)

Line 1802: msc_supplies ms

1798: to_number(null) stock_outs_count
1799:
1800: from msc_full_pegging mfp,
1801: msc_hub_query peg_vmi,
1802: msc_supplies ms
1803: where ms.plan_id=mfp.plan_id
1804: and ms.TRANSACTION_ID = mfp.TRANSACTION_ID
1805: and ms.sr_instance_id = mfp.sr_instance_id
1806: and mfp.plan_id =p_plan_id