DBA Data[Home] [Help]

APPS.MSD_WF dependencies on FND_PROFILE

Line 903: select fnd_profile.value('MSD_CODE_AW') into codeDBName from dual;

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;
904:
905: codeDBName := nvl(codeDBName, 'ODPCODE');
906:
907: numDaysToCol := to_number(NumDays_to_collect);