DBA Data[Home] [Help]

APPS.MSC_VERTICAL_PLAN_SC dependencies on MSC_VERTICAL_PLAN_V

Line 29: from msc_vertical_plan_v plan

25: 70,
26: decode(nvl(produces_to_stock,2),1, quantity_rate,0),92,
27: decode(nvl(produces_to_stock,2),1, quantity_rate,0),
28: decode(NVL(item_type_value,1),1,quantity_rate,0))) new_quantity
29: from msc_vertical_plan_v plan
30: where plan.inventory_item_id = arg_item_id
31: and plan.organization_id = arg_org_id
32: and plan.plan_id = arg_plan_id
33: and plan.sr_instance_id = arg_instance_id