DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_SYSTEM_ITEMS

Line 889: msc_system_items msi,

885: nvl(md.item_type_value,1) part_condition,
886: md.quantity_by_due_date constrained_fcst
887: from
888: msc_demands md,
889: msc_system_items msi,
890: msc_system_items msia,
891: msc_system_items msib
892: where md.plan_id = msia.plan_id
893: and md.sr_instance_id = msia.sr_instance_id

Line 890: msc_system_items msia,

886: md.quantity_by_due_date constrained_fcst
887: from
888: msc_demands md,
889: msc_system_items msi,
890: msc_system_items msia,
891: msc_system_items msib
892: where md.plan_id = msia.plan_id
893: and md.sr_instance_id = msia.sr_instance_id
894: and md.organization_id = msia.organization_id

Line 891: msc_system_items msib

887: from
888: msc_demands md,
889: msc_system_items msi,
890: msc_system_items msia,
891: msc_system_items msib
892: where md.plan_id = msia.plan_id
893: and md.sr_instance_id = msia.sr_instance_id
894: and md.organization_id = msia.organization_id
895: and md.using_assembly_item_id = msia.inventory_item_id

Line 935: msc_system_items msi,

931: nvl(md.item_type_value,1) part_condition,
932: (md.using_requirement_quantity - nvl(md.quantity_by_due_date, 0)) constrained_fcst
933: from
934: msc_demands md,
935: msc_system_items msi,
936: msc_system_items msia,
937: msc_system_items msib
938: where md.plan_id = msia.plan_id
939: and md.sr_instance_id = msia.sr_instance_id

Line 936: msc_system_items msia,

932: (md.using_requirement_quantity - nvl(md.quantity_by_due_date, 0)) constrained_fcst
933: from
934: msc_demands md,
935: msc_system_items msi,
936: msc_system_items msia,
937: msc_system_items msib
938: where md.plan_id = msia.plan_id
939: and md.sr_instance_id = msia.sr_instance_id
940: and md.organization_id = msia.organization_id

Line 937: msc_system_items msib

933: from
934: msc_demands md,
935: msc_system_items msi,
936: msc_system_items msia,
937: msc_system_items msib
938: where md.plan_id = msia.plan_id
939: and md.sr_instance_id = msia.sr_instance_id
940: and md.organization_id = msia.organization_id
941: and md.using_assembly_item_id = msia.inventory_item_id