APPS.MSD_WF dependencies on MSC_TRADING_PARTNERS

Line 893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code

889: from msd_demand_plans_v
890: where demand_plan_name=PlanName;
891:
892: -- Get organiztion code and instance
893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id

Line 895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v

891:
892: -- Get organiztion code and instance
893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3

Line 897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id

893: SELECT msc_trading_partners.organization_code, msc_apps_instances.instance_code
894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
901:

Line 898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id

894: INTO org, instcode
895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
901:
902: --get MSD code database name

Line 899: and msc_trading_partners.partner_type = 3

895: FROM msc_trading_partners, msc_apps_instances, msd_demand_plans_v
896: WHERE PlanID = msd_demand_plans_v.DEMAND_PLAN_ID AND
897: msd_demand_plans_v.ORGANIZATION_ID = msc_trading_partners.sr_tp_id
898: and msd_demand_plans_v.sr_instance_id = msc_trading_partners.sr_instance_id
899: and msc_trading_partners.partner_type = 3
900: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
901:
902: --get MSD code database name
903: select fnd_profile.value('MSD_CODE_AW') into codeDBName from dual;