You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql query

edited Oct 30, 2024 7:56PM in Supply Chain Planning and Collaboration 2 comments

How to get details of intransit_time(MSC_INTERORG_SHIP_METHODS) in Sourcing Rule with sql query(Fusion).

SELECT INTRANSIT_TIME
FROM
msc_interorg_ship_methods mism,
msc_sr_source_org msso
WHERE
mism.mode_of_transport = msso.mode_of_transport
AND mism.service_level = msso.service_level
AND mism.carrier_id = msso.carrier_id
AND mism.origin_id = msso.source_org

It is giving right results for above query

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!