APPS.MSC_EXCEPTION_PKG dependencies on MSC_TRADING_PARTNERS

Line 355: msc_trading_partners mtp,

351:
352: from
353: msc_exception_details med,
354: msc_apcc_item_d msi,
355: msc_trading_partners mtp,
356: msc_supplies ms,
357: msc_demands md,
358: msc_full_pegging mfp,
359: msc_demands md2

Line 561: msc_trading_partners mtp

557: msc_exception_details med
558: where med.plan_id=p_plan_id
559: and l_plan_type = 6) t,
560: msc_apcc_item_d msi,
561: msc_trading_partners mtp
562: where msi.plan_id(+) = t.plan_id
563: and msi.inventory_item_id(+) = t.inventory_item_id
564: and msi.organization_id(+) = t.owning_org_id
565: and msi.sr_instance_id(+) = t.owning_inst_id

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

892: ' fnd_global.user_id, sysdate,'||
893: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
894: ' from'||
895: ' '||l_apps_schema||'.msc_exceptions_f'||l_suffix||' f,'||
896: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
897: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
898: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
899: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
900: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv,'||

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

893: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
894: ' from'||
895: ' '||l_apps_schema||'.msc_exceptions_f'||l_suffix||' f,'||
896: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
897: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
898: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
899: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv,'||
900: ' '||l_apps_schema||'.msc_phub_suppliers_mv'||l_suffix||' smv,'||
901: ' '||l_apps_schema||'.msc_department_resources'||l_suffix||' mdr,';