DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PKG dependencies on MSC_TRADING_PARTNERS

Line 231: msc_trading_partners mtp,

227: nvl(mscp.capacity, 1e20) avail_qty
228: from
229: msc_supplier_capacities mscp,
230: msc_calendar_dates mcd,
231: msc_trading_partners mtp,
232: msc_item_suppliers mis
233: where l_plan_type not in (6)
234: and mscp.capacity > 0
235: and mis.plan_id=mscp.plan_id

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

691: ' fnd_global.user_id, sysdate,'||
692: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
693: ' from'||
694: ' '||l_apps_schema||'.msc_suppliers_f'||l_suffix||' f,'||
695: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
696: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
697: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
698: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv'||
699: ' where f.plan_run_id=:p_plan_run_id'||

Line 696: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

692: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
693: ' from'||
694: ' '||l_apps_schema||'.msc_suppliers_f'||l_suffix||' f,'||
695: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
696: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
697: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
698: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv'||
699: ' where f.plan_run_id=:p_plan_run_id'||
700: ' and f.aggr_type=0'||