748: fnd_global.login_id
749: from csp_plan_details cpd,
750: csp_planning_parameters cpp,
751: csp_forecast_rules_b cfrb,
752: mtl_material_transactions mmt,
753: csp_usg_transaction_types cutt
754: where cpd.plan_detail_type in ('9002','9003')
755: and cpd.organization_id = l_organization_id
756: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)