APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_TRADING_PARTNERS

Line 1150: msc_trading_partners tp,

1146: to_number(null),
1147: to_char(NULL)
1148: FROM msc_interorg_ship_methods sm,
1149: msc_form_query list,
1150: msc_trading_partners tp,
1151: msc_calendar_dates cal
1152: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1153: AND cal.exception_set_id = tp.calendar_exception_set_id
1154: AND cal.calendar_code = tp.calendar_code

Line 1178: msc_trading_partners tp,

1174: , to_number(null),
1175: to_char(NULL)
1176: FROM msc_interorg_ship_methods sm,
1177: msc_form_query list,
1178: msc_trading_partners tp,
1179: msc_calendar_dates cal
1180: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1181: AND cal.exception_set_id = tp.calendar_exception_set_id
1182: AND cal.calendar_code = tp.calendar_code

Line 1287: FROM msc_trading_partners tp,

1283: WHERE plan_id = g_designator;
1284:
1285: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
1286: SELECT cal.calendar_date
1287: FROM msc_trading_partners tp,
1288: msc_calendar_dates cal
1289: WHERE tp.sr_tp_id = g_org_id
1290: AND tp.sr_instance_id = g_inst_id
1291: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 1352: FROM msc_trading_partners

1348: -- initialize calendar code
1349: -- --------------------------
1350: SELECT calendar_code, calendar_exception_set_id
1351: INTO g_calendar_code, g_exc_set_id
1352: FROM msc_trading_partners
1353: WHERE sr_tp_id = g_org_id
1354: AND sr_instance_id = g_inst_id
1355: AND partner_type = 3;
1356:

Line 1401: msc_trading_partners mtp

1397: p_date Date) return boolean IS
1398: CURSOR work_c IS
1399: select mca.seq_num
1400: from msc_calendar_dates mca,
1401: msc_trading_partners mtp
1402: where mtp.sr_tp_id = p_org_id
1403: and mtp.sr_instance_id = p_inst_id
1404: and mtp.partner_type = 3
1405: and mca.calendar_code = mtp.calendar_code

Line 2251: FROM msc_trading_partners

2247: -- dbms_output.put_line(g_error_stmt);
2248: -- ----------------------------
2249: SELECT calendar_code, calendar_exception_set_id
2250: INTO g_calendar_code, g_exc_set_id
2251: FROM msc_trading_partners
2252: WHERE sr_tp_id = activity_rec.org_id
2253: AND sr_instance_id = activity_rec.instance_id
2254: AND partner_type = 3;
2255: