DBA Data[Home] [Help]

APPS.MSC_REL_WF dependencies on MSC_TRADING_PARTNERS

Line 832: msc_trading_partners mp,

828: p_operating_unit,
829: p_action
830: FROM msc_apps_instances mai, -- xml fix
831: msc_system_items msi,
832: msc_trading_partners mp,
833: msc_supplies s
834: WHERE msi.inventory_item_id = s.inventory_item_id
835: AND msi.plan_id = s.plan_id
836: AND msi.organization_id = s.organization_id

Line 1318: msc_trading_partners mtp

1314: p_original_item_id,
1315: p_substitute_item_id,
1316: p_org_id
1317: FROM msc_demands md,
1318: msc_trading_partners mtp
1319: WHERE md.plan_id = arg_plan_id
1320: AND md.release_errors is NULL
1321: and md.load_type = 30
1322: and md.origination_type = 30

Line 2228: msc_trading_partners mtp

2224: msc_system_items msi,
2225: msc_plans mp,
2226: msc_calendar_dates cal1,
2227: msc_calendar_dates cal2,
2228: msc_trading_partners mtp
2229: where s.plan_id = p_plan_id
2230: and s.transaction_id =p_transaction_id
2231: and s.plan_id = mp.plan_id
2232: and s.plan_id = msi.plan_id