DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on MSC_COMPONENT_SUBSTITUTES

Line 3894: FROM msc_system_items msi, msc_component_substitutes sub,

3890: ,comp.scale_rounding_variance scale_rounding_variance
3891: ,comp.rounding_direction rounding_direction
3892: ,comp.component_yield_factor component_yield_factor
3893:
3894: FROM msc_system_items msi, msc_component_substitutes sub,
3895: msc_bom_components comp, msc_boms bom, msc_system_items ch,
3896: msc_system_items pt, mrp_atp_details_temp peg
3897: WHERE peg.session_id = MSC_ATP_PVT.G_SESSION_ID
3898: AND peg.pegging_id = p_parent_pegging_id

Line 3970: FROM msc_system_items msi, msc_component_substitutes sub,

3966: ,comp.rounding_direction rounding_direction
3967: ,comp.component_yield_factor component_yield_factor
3968: ,sub.usage_quantity/(comp.usage_quantity*comp.component_yield_factor) usage_qty --4775920
3969:
3970: FROM msc_system_items msi, msc_component_substitutes sub,
3971: msc_bom_components comp, msc_system_items ch
3972: WHERE ch.plan_id = p_plan_id
3973: AND ch.organization_id = p_organization_id
3974: AND ch.sr_instance_id = p_instance_id