APPS.MSC_SCH_WB dependencies on MSC_TRADING_PARTNERS

Line 727: ' msc_trading_partners'||l_dblink||' mtp '||

723:
724: sqlstring :=
725: 'SELECT rule_name '||
726: ' FROM msc_atp_rules'||l_dblink||' mar, '||
727: ' msc_trading_partners'||l_dblink||' mtp '||
728: ' WHERE '||
729: ' mar.rule_id = mtp.default_atp_rule_id '||
730: ' AND mar.sr_instance_id = mtp.sr_instance_id '||
731: ' AND mtp.sr_tp_id = :org_id '||

Line 1098: from msc_trading_partners p, msc_cal_week_start_dates b

1094: and b.period_start_date <= v_period_end_date;
1095:
1096: cursor msc_wk_cur is
1097: select b.week_start_date
1098: from msc_trading_partners p, msc_cal_week_start_dates b
1099: where p.calendar_exception_set_id = b.exception_set_id
1100: AND p.sr_instance_id = p_sr_instance_id
1101: AND b.sr_instance_id = p.sr_instance_id
1102: and p.calendar_code = b.calendar_code

Line 1110: from msc_trading_partners p, MSC_period_START_DATES b

1106: and b.week_start_date <= v_week_end_date;
1107:
1108: cursor msc_pr_cur is
1109: select b.period_start_date
1110: from msc_trading_partners p, MSC_period_START_DATES b
1111: where p.calendar_exception_set_id = b.exception_set_id
1112: AND p.sr_instance_id = p_sr_instance_id
1113: AND b.sr_instance_id = p.sr_instance_id
1114: and p.calendar_code = b.calendar_code