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 2113: FROM msc_trading_partners

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

Line 2325: msc_trading_partners tp

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

Line 2967: MSC_TRADING_PARTNERS TP

2963: FROM MSC_SYSTEM_ITEMS I,
2964: MSC_BOMS MB,
2965: MSC_BOM_COMPONENTS MBC,
2966: MSC_CALENDAR_DATES C,
2967: MSC_TRADING_PARTNERS TP
2968: WHERE I.plan_id = p_plan_id and
2969: I.sr_instance_id = p_instance_id and
2970: I.organization_id = p_org_id and
2971: I.sr_inventory_item_id = p_inv_item_id and

Line 3516: FROM msc_trading_partners

3512: IF l_sources.organization_id(j) <> -1 THEN
3513: BEGIN
3514: SELECT organization_code
3515: INTO l_other_cols.org_code(j)
3516: FROM msc_trading_partners
3517: WHERE sr_tp_id = l_sources.organization_id(j)
3518: AND sr_instance_id = l_sources.instance_id(j)
3519: AND partner_type = 3;
3520: EXCEPTION

Line 3537: msc_trading_partners mtp

3533: SELECT mtil.sr_tp_id, mtp.partner_name
3534: INTO l_other_cols.sr_supplier_id(j),
3535: l_other_cols.vendor_name(j)
3536: FROM msc_tp_id_lid mtil,
3537: msc_trading_partners mtp
3538: WHERE mtil.tp_id = mtp.partner_id
3539: AND mtil.sr_instance_id = l_sources.instance_id(j)
3540: AND mtil.partner_type = 1
3541: AND mtp.partner_id = l_sources.supplier_id(j);

Line 4560: FROM msc_trading_partners tp, msc_parameters mp

4556: x_org_attribute_rec.org_type, --(ssurendr) Bug 2865389
4557: x_org_attribute_rec.network_scheduling_method, --bug3601223
4558: x_org_attribute_rec.use_phantom_routings --4570421
4559:
4560: FROM msc_trading_partners tp, msc_parameters mp
4561: WHERE tp.sr_tp_id = p_organization_id
4562: AND tp.sr_instance_id = p_instance_id
4563: AND tp.partner_type = 3
4564: AND mp.ORGANIZATION_ID(+) = tp.sr_tp_id

Line 4793: msc_trading_partners tp,

4789: INTO l_infinite_time_fence_date, x_atp_rule_name
4790: FROM msc_calendar_dates c2,
4791: msc_calendar_dates c1,
4792: msc_atp_rules r,
4793: msc_trading_partners tp,
4794: msc_system_items i
4795: WHERE i.sr_inventory_item_id = p_inventory_item_id
4796: AND i.organization_id = p_organization_id
4797: --AND i.plan_id = p_plan_id

Line 4837: msc_trading_partners tp,

4833: INTO l_infinite_time_fence_date, x_atp_rule_name
4834: FROM msc_calendar_dates c2,
4835: msc_calendar_dates c1,
4836: msc_atp_rules r,
4837: msc_trading_partners tp,
4838: msc_department_resources dep_res
4839: WHERE dep_res.resource_id = p_resource_id
4840: AND dep_res.department_id = p_department_id
4841: AND dep_res.organization_id = p_organization_id