APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_TRADING_PARTNERS

Line 975: msc_trading_partners tp,

971: to_number(null),
972: to_char(NULL)
973: FROM msc_interorg_ship_methods sm,
974: msc_form_query list,
975: msc_trading_partners tp,
976: msc_calendar_dates cal
977: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
978: AND cal.exception_set_id = tp.calendar_exception_set_id
979: AND cal.calendar_code = tp.calendar_code

Line 1003: msc_trading_partners tp,

999: , to_number(null),
1000: to_char(NULL)
1001: FROM msc_interorg_ship_methods sm,
1002: msc_form_query list,
1003: msc_trading_partners tp,
1004: msc_calendar_dates cal
1005: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1006: AND cal.exception_set_id = tp.calendar_exception_set_id
1007: AND cal.calendar_code = tp.calendar_code

Line 1112: FROM msc_trading_partners tp,

1108: WHERE plan_id = g_designator;
1109:
1110: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
1111: SELECT cal.calendar_date
1112: FROM msc_trading_partners tp,
1113: msc_calendar_dates cal
1114: WHERE tp.sr_tp_id = g_org_id
1115: AND tp.sr_instance_id = g_inst_id
1116: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 1177: FROM msc_trading_partners

1173: -- initialize calendar code
1174: -- --------------------------
1175: SELECT calendar_code, calendar_exception_set_id
1176: INTO g_calendar_code, g_exc_set_id
1177: FROM msc_trading_partners
1178: WHERE sr_tp_id = g_org_id
1179: AND sr_instance_id = g_inst_id
1180: AND partner_type = 3;
1181:

Line 1226: msc_trading_partners mtp

1222: p_date Date) return boolean IS
1223: CURSOR work_c IS
1224: select mca.seq_num
1225: from msc_calendar_dates mca,
1226: msc_trading_partners mtp
1227: where mtp.sr_tp_id = p_org_id
1228: and mtp.sr_instance_id = p_inst_id
1229: and mtp.partner_type = 3
1230: and mca.calendar_code = mtp.calendar_code

Line 2003: FROM msc_trading_partners

1999: -- dbms_output.put_line(g_error_stmt);
2000: -- ----------------------------
2001: SELECT calendar_code, calendar_exception_set_id
2002: INTO g_calendar_code, g_exc_set_id
2003: FROM msc_trading_partners
2004: WHERE sr_tp_id = activity_rec.org_id
2005: AND sr_instance_id = activity_rec.instance_id
2006: AND partner_type = 3;
2007: