DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_SAFETY_STOCKS

Line 1983: FROM msc_plan_organizations mpo, msc_safety_stocks mss,

1979: 0 AS nr_sl_records,
1980: NULL AS partner_id,
1981: NULL AS customer_class_code,
1982: RECORD_SAFETY_STOCK AS record_type
1983: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
1984: msc_system_items msi, msc_item_categories mic
1985: WHERE mss.sr_instance_id = msi.sr_instance_id
1986: AND mss.plan_id = msi.plan_id
1987: AND mss.organization_id = msi.organization_id

Line 2046: FROM msc_plan_organizations mpo, msc_safety_stocks mss,

2042: 0 AS nr_sl_records,
2043: NULL AS partner_id,
2044: NULL AS customer_class_code,
2045: RECORD_SAFETY_STOCK AS record_type
2046: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
2047: msc_system_items msi, msc_item_categories mic,
2048: msc_plan_buckets mpb
2049: WHERE mss.sr_instance_id = msi.sr_instance_id
2050: AND mss.plan_id = msi.plan_id

Line 2213: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,

2209: 0 AS nr_sl_records,
2210: NULL AS partner_id,
2211: NULL AS customer_class_code,
2212: RECORD_SAFETY_STOCK AS record_type
2213: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
2214: msc_plans mp, msc_plan_organizations mpo
2215: WHERE mss.sr_instance_id = msi.sr_instance_id
2216: AND mss.plan_id = msi.plan_id
2217: AND mss.organization_id = msi.organization_id