APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_TRADING_PARTNERS

Line 70: ,msc_trading_partners tp

66: v_stmt := 10;
67: select TRUNC(MIN(calendar_date))
68: into v_start_date
69: from msc_calendar_dates cal
70: ,msc_trading_partners tp
71: where tp.sr_tp_id = arg_organization_id
72: and tp.sr_instance_id = arg_sr_instance_id
73: and tp.partner_type = 3
74: and cal.calendar_code = tp.calendar_code

Line 99: ,msc_trading_partners tp

95: v_stmt := 20;
96: select TRUNC(MAX(calendar_date))
97: into v_cutoff_date
98: from msc_calendar_dates cal
99: ,msc_trading_partners tp
100: where tp.sr_tp_id = arg_organization_id
101: and tp.sr_instance_id = arg_sr_instance_id
102: and tp.partner_type = 3
103: and cal.calendar_code = tp.calendar_code

Line 1216: FROM msc_trading_partners org,

1212: NVL(dept_res.capacity_units,1), --**
1213: dept_res.disable_date, --**
1214: org.calendar_code, --**
1215: org.calendar_exception_set_id --**
1216: FROM msc_trading_partners org,
1217: msc_department_resources dept_res
1218: WHERE dept_res.owning_department_id = dept_res.department_id
1219: AND dept_res.plan_id = -1
1220: AND dept_res.resource_id <> -1

Line 1242: FROM msc_trading_partners org,

1238: NVL(dept_res.capacity_units,1), --**
1239: dept_res.disable_date, --**
1240: org.calendar_code, --**
1241: org.calendar_exception_set_id --**
1242: FROM msc_trading_partners org,
1243: msc_resource_changes chg,
1244: msc_department_resources dept_res
1245: WHERE chg.department_id = dept_res.department_id
1246: AND chg.resource_id = dept_res.resource_id

Line 1649: msc_trading_partners org

1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1647: FROM msc_calendar_dates dates,
1648: msc_department_resources line,
1649: msc_trading_partners org
1650: WHERE line.organization_id = arg_organization_id
1651: AND line.sr_instance_id = arg_sr_instance_id
1652: AND line.line_flag = 1
1653: AND line.plan_id = -1

Line 1717: msc_trading_partners org

1713: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1714: ,arg_refresh_number
1715: FROM
1716: msc_department_resources line,
1717: msc_trading_partners org
1718: WHERE line.organization_id = arg_organization_id
1719: AND line.sr_instance_id = arg_sr_instance_id
1720: AND line.line_flag = 1
1721: AND line.plan_id = -1

Line 1806: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||

1802: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1803:
1804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);
1805:
1806: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||
1807: ' SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id ||
1808: ' AND ORGANIZATION_TYPE =1 ) ';
1809:
1810: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');

Line 1895: MSC_TRADING_PARTNERS mtp

1891: CURSOR c1 IS
1892: SELECT tp.Organization_ID
1893: FROM MSC_PARAMETERS tp,
1894: MSC_INSTANCE_ORGS ins_org,
1895: MSC_TRADING_PARTNERS mtp
1896: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1897: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1898: AND ins_org.Organization_ID=tp.ORGANIZATION_ID
1899: AND ins_org.ENABLED_FLAG= MSC_UTIL.SYS_YES

Line 2268: msc_trading_partners mtp

2264:
2265: CURSOR c_org_list IS
2266: select organization_id
2267: from msc_instance_orgs mio,
2268: msc_trading_partners mtp
2269: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2270: mio.enabled_flag= 1 and
2271: ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (mio.org_group = MSC_CL_COLLECTION.v_coll_prec.org_group_flag)) and
2272: mio.sr_instance_id=mtp.sr_instance_id and