APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on MSC_TRADING_PARTNERS

Line 242: from msc_cal_week_start_dates cal , msc_trading_partners mtp

238: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_err_mesg: '||v_err_mesg);
239:
240: select min(cal.week_start_date)
241: into v_weekly_start_date
242: from msc_cal_week_start_dates cal , msc_trading_partners mtp
243: where cal.exception_set_id = mtp.calendar_exception_set_id
244: and cal.calendar_code = mtp.calendar_code
245: and cal.week_start_date >= trunc(v_daily_cutoff_date)
246: and cal.sr_instance_id = G_inst_id

Line 255: from msc_period_start_dates cal , msc_trading_partners mtp

251: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' v_weekly_start_date: '||TO_CHAR(v_weekly_start_date,'DD-MON-YYYY'));
252:
253: select min(cal.period_start_date)
254: into v_period_start_date
255: from msc_period_start_dates cal , msc_trading_partners mtp
256: where cal.exception_set_id = mtp.calendar_exception_set_id
257: and cal.calendar_code = mtp.calendar_code
258: and cal.period_start_date >= nvl(trunc(v_weekly_cutoff_date),trunc(v_daily_cutoff_date))
259: and cal.sr_instance_id = G_inst_id

Line 898: ' msc_trading_partners mtp, '||

894: -- msc_item_categories mic,
895: -- ' msc_system_items msi,
896: ' gmp_pdr_items_gtmp gpi, '||
897: ' msc_supplies sup, '||
898: ' msc_trading_partners mtp, '||
899: ' msc_calendar_dates cal, '||
900: ' mfg_lookups l1, '||
901: ' msc_plans mp '||
902: ' WHERE cal.calendar_date BETWEEN TRUNC (sup.new_schedule_date) '||

Line 996: ' msc_trading_partners mtp, '||

992: -- msc_item_categories mic,
993: -- ' msc_system_items msi,
994: ' gmp_pdr_items_gtmp gpi, '||
995: ' msc_demands dem, '||
996: ' msc_trading_partners mtp, '||
997: ' msc_calendar_dates cal, '||
998: ' mfg_lookups l1, '||
999: ' msc_plans mp '||
1000: ' WHERE cal.calendar_date BETWEEN TRUNC (dem.using_assembly_demand_date) '||

Line 1161: ' msc_trading_partners mtp, '||

1157: ' FROM '||
1158: ' gmp_pdr_items_gtmp gpi, '||
1159: ' msc_supplies sup, '||
1160: ' msc_calendar_dates cal, '||
1161: ' msc_trading_partners mtp, '||
1162: ' mfg_lookups l1 '||
1163: ' WHERE '||
1164: ' cal.calendar_date BETWEEN TRUNC (sup.new_schedule_date) '||
1165: ' AND NVL (TRUNC (sup.last_unit_completion_date), '||