APPS.MSC_ITEM_PKG dependencies on MSC_SAFETY_STOCKS

Line 449: from msc_safety_stocks mss, msc_hub_query vmi

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,
448: nvl(vmi.number6, 0) vmi_flag
449: from msc_safety_stocks mss, msc_hub_query vmi
450: where mss.plan_id=p_plan_id
451: and mss.plan_id=vmi.number1(+)
452: and mss.sr_instance_id=vmi.number3(+)
453: and mss.organization_id=vmi.number4(+)

Line 899: -- we only calculate ss for items in msc_safety_stocks

895: commit;
896:
897: -----------------------------------------------------------
898: -- get safety stock item
899: -- we only calculate ss for items in msc_safety_stocks
900: --
901: ------------------------------------------------------------
902:
903: l_stmt_id :=70;

Line 943: from msc_safety_stocks mss,

939: f2.date4,
940: f2.date5,
941: f2.number10,
942: f2.number11
943: from msc_safety_stocks mss,
944: (select distinct
945: t_bucket.date1, -- bkt_start_date,
946: t_bucket.date2, -- bkt_end_date
947: t_bucket.date3, -- last work date

Line 969: -- rows in msc_safety_stocks

965: commit;
966:
967: --------------------------------------------------------------------
968: --- now calculate ss, ss is distributed to bucket start date based on
969: -- rows in msc_safety_stocks
970: -- inventory_level,ss,il is then moved to last date of week/period/month
971: --------------------------------------------------------------------
972:
973:

Line 1017: from msc_safety_stocks mss,

1013: ORDER by f.date1) safety_stock_qty ,
1014: LAST_VALUE(mss.user_defined_safety_stocks ignore nulls)
1015: OVER (PARTITION BY f.number1,f.number3,f.number4,f.number5
1016: ORDER by f.date1) user_defined_safety_stock_qty
1017: from msc_safety_stocks mss,
1018: msc_hub_query f
1019: where f.query_id=l_qid_ss_item
1020: and f.number1 = mss.plan_id(+)
1021: and f.number3 = mss.sr_instance_id(+)