APPS.MSC_REL_WF dependencies on MSC_TRADING_PARTNERS

Line 696: from msc_trading_partners mtp

692: dock_date Date;
693: cursor mfg_calendar_code(p_organization_id NUMBER,
694: p_sr_instance_id NUMBER) IS
695: select mtp.calendar_code
696: from msc_trading_partners mtp
697: where mtp.sr_tp_id = p_organization_id
698: and mtp.sr_instance_id = p_sr_instance_id
699: and mtp.partner_type = 3;
700:

Line 859: msc_trading_partners mp,

855: p_operating_unit,
856: p_action
857: FROM msc_apps_instances mai, -- xml fix
858: msc_system_items msi,
859: msc_trading_partners mp,
860: msc_supplies s
861: WHERE msi.inventory_item_id = s.inventory_item_id
862: AND msi.plan_id = s.plan_id
863: AND msi.organization_id = s.organization_id

Line 920: msc_trading_partners mp,

916: p_operating_unit,
917: p_action
918: FROM msc_apps_instances mai, -- xml fix
919: msc_system_items msi,
920: msc_trading_partners mp,
921: msc_supplies s
922: WHERE msi.inventory_item_id = s.inventory_item_id
923: AND msi.plan_id = s.plan_id
924: AND msi.organization_id = s.organization_id

Line 1481: msc_trading_partners mtp

1477: p_original_item_id,
1478: p_substitute_item_id,
1479: p_org_id
1480: FROM msc_demands md,
1481: msc_trading_partners mtp
1482: WHERE md.plan_id = arg_plan_id
1483: AND md.release_errors is NULL
1484: and md.load_type = 30
1485: and md.origination_type = 30

Line 1548: msc_trading_partners mtp

1544: p_original_item_id,
1545: p_substitute_item_id,
1546: p_org_id
1547: FROM msc_demands md,
1548: msc_trading_partners mtp
1549: WHERE md.plan_id = arg_plan_id
1550: AND md.release_errors is NULL
1551: and md.load_type = 30
1552: and md.origination_type = 30

Line 2479: msc_trading_partners mtp

2475: msc_system_items msi,
2476: msc_plans mp,
2477: msc_calendar_dates cal1,
2478: msc_calendar_dates cal2,
2479: msc_trading_partners mtp
2480: where s.plan_id = p_plan_id
2481: and s.transaction_id =p_transaction_id
2482: and s.plan_id = mp.plan_id
2483: and s.plan_id = msi.plan_id