DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on MTL_INTERORG_SHIP_METHODS

Line 425: FROM MTL_INTERORG_SHIP_METHODS

421: if (p_shipping_method is null) or (p_shipping_method = fnd_api.g_miss_char) then
422: Begin
423: SELECT SHIP_METHOD
424: INTO l_shipping_method_code
425: FROM MTL_INTERORG_SHIP_METHODS
426: WHERE FROM_ORGANIZATION_ID = P_repair_supplier_org_id
427: AND TO_ORGANIZATION_ID = P_dest_organization_id
428: AND FROM_LOCATION_ID = l_supplier_org_location_id
429: AND TO_LOCATION_ID = l_ship_to_location_id