eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PROC dependencies on MSC_TRADING_PARTNERS

Line 2114: FROM msc_trading_partners

2110: x_calendar_code,
2111: x_calendar_exception_set_id,
2112: x_default_demand_class,
2113: x_org_code
2114: FROM msc_trading_partners
2115: WHERE sr_tp_id = p_organization_id
2116: AND sr_instance_id = p_instance_id
2117: AND partner_type = 3;
2118:

Line 2326: msc_trading_partners tp

2322: WHERE sr_instance_id = p_instance_id
2323: AND rule_id IN (
2324: SELECT distinct NVL(mi.atp_rule_id, tp.default_atp_rule_id)
2325: FROM msc_system_items mi,
2326: msc_trading_partners tp
2327: WHERE mi.organization_id = tp.sr_tp_id
2328: AND mi.sr_instance_id = tp.sr_instance_id
2329: AND tp.partner_type = 3
2330: AND mi.plan_id = -1

Line 2975: MSC_TRADING_PARTNERS TP

2971: FROM MSC_SYSTEM_ITEMS I,
2972: MSC_BOMS MB,
2973: MSC_BOM_COMPONENTS MBC,
2974: MSC_CALENDAR_DATES C,
2975: MSC_TRADING_PARTNERS TP
2976: WHERE I.plan_id = p_plan_id and
2977: I.sr_instance_id = p_instance_id and
2978: I.organization_id = p_org_id and
2979: I.sr_inventory_item_id = p_inv_item_id and

Line 3525: FROM msc_trading_partners

3521: IF l_sources.organization_id(j) <> -1 THEN
3522: BEGIN
3523: SELECT organization_code
3524: INTO l_other_cols.org_code(j)
3525: FROM msc_trading_partners
3526: WHERE sr_tp_id = l_sources.organization_id(j)
3527: AND sr_instance_id = l_sources.instance_id(j)
3528: AND partner_type = 3;
3529: EXCEPTION

Line 3546: msc_trading_partners mtp

3542: SELECT mtil.sr_tp_id, mtp.partner_name
3543: INTO l_other_cols.sr_supplier_id(j),
3544: l_other_cols.vendor_name(j)
3545: FROM msc_tp_id_lid mtil,
3546: msc_trading_partners mtp
3547: WHERE mtil.tp_id = mtp.partner_id
3548: AND mtil.sr_instance_id = l_sources.instance_id(j)
3549: AND mtil.partner_type = 1
3550: AND mtp.partner_id = l_sources.supplier_id(j);

Line 4569: FROM msc_trading_partners tp, msc_parameters mp

4565: x_org_attribute_rec.org_type, --(ssurendr) Bug 2865389
4566: x_org_attribute_rec.network_scheduling_method, --bug3601223
4567: x_org_attribute_rec.use_phantom_routings --4570421
4568:
4569: FROM msc_trading_partners tp, msc_parameters mp
4570: WHERE tp.sr_tp_id = p_organization_id
4571: AND tp.sr_instance_id = p_instance_id
4572: AND tp.partner_type = 3
4573: AND mp.ORGANIZATION_ID(+) = tp.sr_tp_id

Line 4802: msc_trading_partners tp,

4798: INTO l_infinite_time_fence_date, x_atp_rule_name
4799: FROM msc_calendar_dates c2,
4800: msc_calendar_dates c1,
4801: msc_atp_rules r,
4802: msc_trading_partners tp,
4803: msc_system_items i
4804: WHERE i.sr_inventory_item_id = p_inventory_item_id
4805: AND i.organization_id = p_organization_id
4806: --AND i.plan_id = p_plan_id

Line 4846: msc_trading_partners tp,

4842: INTO l_infinite_time_fence_date, x_atp_rule_name
4843: FROM msc_calendar_dates c2,
4844: msc_calendar_dates c1,
4845: msc_atp_rules r,
4846: msc_trading_partners tp,
4847: msc_department_resources dep_res
4848: WHERE dep_res.resource_id = p_resource_id
4849: AND dep_res.department_id = p_department_id
4850: AND dep_res.organization_id = p_organization_id