DBA Data[Home] [Help]

APPS.MSD_SOP dependencies on FND_PROFILE

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

82: and msc_trading_partners.partner_type = 3
83: AND msd_demand_plans_v.SR_INSTANCE_ID = msc_apps_instances.instance_id;
84:
85: --get MSD code database name
86: select fnd_profile.value('MSD_CODE_AW') into codeDBName from dual;
87:
88: codeDBName := nvl(codeDBName, 'ODPCODE');
89:
90: numDaysToCol := to_number(Days_tocollect);