DBA Data[Home] [Help]

APPS.MSC_PHUB_BUDGET_PKG dependencies on MSC_TRADING_PARTNERS

Line 107: msc_trading_partners mtp

103: b.sr_category_id,
104: b.budget_value
105: from
106: msc_inventory_budget_values b,
107: msc_trading_partners mtp
108: where budget_id=l_budget_id
109: and b.sr_instance_id=mtp.sr_instance_id(+)
110: and b.organization_id=mtp.sr_tp_id(+)
111: and mtp.partner_type(+)=3

Line 232: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

228: ' fnd_global.user_id, sysdate,'||
229: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
230: ' from'||
231: ' '||l_apps_schema||'.msc_budgets_f'||l_suffix||' f,'||
232: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
233: ' '||l_apps_schema||'.msc_phub_categories_mv'||l_suffix||' c,'||
234: ' '||l_apps_schema||'.msc_apps_instances'||l_suffix||' mai'||
235: ' where f.plan_run_id=:p_plan_run_id'||
236: ' and mtp.partner_type(+)=3'||